Inserting Data to Multiple Sheet at once

In the typing of data sometimes there are situations where we have to enter the data into multiple sheets at once just like using multiple sheets of carbon to form. For the easy way, before typing the data-sheet select the sheet that will enter the same data. If the sheet layout consecutive click the first sheet and press SHIFT and click the last sheet. If the sheet layout is not sequential use the CTRL key to select one by one. Once the desired sheet-sheet-elect begin typing data. At that time your whole treatment (data typing, change the column width, and so on) on the worksheet will be valid and occur at the entire sheet selected.

Displaying Several Other Worksheet Together

If there are multiple worksheet from the same workbook that you want to show together, do the following:

1. On the View tab, in the Window group, click New Window. It was in the Windows task bar will appear New Windows 1.
2. Switch to the new window and then click the tab you want to view.
3. Repeat this step so that every sheet you want to display together have created a new window.
4. Click the Arrange button and select Tile. Click OK.