Microsoft Office Tutorials and References
In Depth Information
Opening Windows on Your Worksheets
select the Create a Copy check box before you click OK. If you copy a
worksheet instead of just moving it, Excel adds a number to the sheet name. For
example, if you copy a sheet named Total Income, Excel automatically names
the copy of the worksheet Total Income (2), which appears on its sheet tab.
Opening Windows on Your Worksheets
Just as you can split a single worksheet into panes so that you can view and
compare different parts of that same sheet on the screen (see Chapter 6), you
can split a single workbook into worksheet windows and then arrange the
windows so that you can view different parts of each worksheet on the screen.
To open the worksheets that you want to compare in different windows, you
simply insert new workbook windows (in addition to the one that Excel
automatically opens when you open the workbook file itself) and then select the
worksheet that you want to display in the new window. You can accomplish
this with the following steps:
1. Click the New Window command button on the View tab or press
Alt+WN to create a second worksheet window; then click the tab of the
worksheet that you want to display in this second window (indicated by
the :2 that Excel adds to the end of the filename in the title bar).
2. Click the New Window command button or press Alt+WN again to
create a third worksheet window; then click the tab of the worksheet
that you want to display in this third window (indicated by the :3 that
Excel adds to the end of the filename in the title bar).
3. Continue clicking the New Window command button or pressing
Alt+WN to create a new window and then selecting the tab of the
worksheet you want to display in that window for each worksheet you
want to compare.
4. Click the Arrange All command button on the View tab or press
Alt+WA and select one of the Arrange options in the Arrange
Windows dialog box (as I describe next); then click OK or press Enter.
When you open the Arrange Windows dialog box, you’re presented with the
following options:
Tiled: Select this button to have Excel arrange and size the windows so
that they all fit side by side on the screen. (Check out Figure 7-4 to see the
screen that appears after you choose the Tiled button to organize four
worksheet windows.)
Horizontal: Select this button to have Excel size the windows equally
and place them one above the other. (In Figure 7-5, you can see the
screen that appears after you choose the Horizontal button to organize
these four worksheet windows.)
Search JabSto ::




Custom Search