Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Maintaining Multiple Worksheets
Going sheet to sheet via the keyboard
You can forget all about the tab scrolling
buttons and sheet tabs and just go back and forth
through the sheets in a workbook with your
keyboard. To move to the next worksheet in a
workbook, press Ctrl+PgDn. To move to the previous
worksheet in a workbook, press Ctrl+PgUp. The
nice thing about using the keyboard shortcuts
Ctrl+PgDn and Ctrl+PgUp is that they work
whether or not the next or previous sheet tab is
displayed in the workbook window!
Just don’t forget that scrolling the sheet tab into view is not the same thing as
selecting it: You still need to click the tab for the desired sheet to bring it to the
front of the stack (or select it in the Activate dialog box shown in Figure 7-1).
To make it easier to find the sheet tab you want to select without having to do
an inordinate amount of tab scrolling, drag the tab split bar (the three vertical
dots that immediately follow the New Sheet button) to the right. Doing this
reveals more sheet tabs on the Status bar, consequently making the horizontal
scroll bar shorter. If you don’t care at all about using the horizontal scroll bar,
you can maximize the number of sheet tabs in view by actually getting rid of
this scroll bar. To do this, drag the tab split bar to the right until it’s smack up
against the vertical split bar.
When you want to restore the horizontal scroll bar to its normal length, you
can either manually drag the tab split bar to the left or simply double-click it.
Editing en masse
Each time you click a sheet tab, you select that worksheet and make it active,
enabling you to make whatever changes are necessary to its cells. You may
encounter times, however, when you want to select bunches of worksheets
so that you can make the same editing changes to all of them simultaneously.
When you select multiple worksheets, any editing change that you make to
the current worksheet — such as entering information in cells or deleting
stuff from them — affects the same cells in all the selected sheets in exactly
the same way.
Suppose you need to set up a new workbook with three worksheets that
contain the names of the months across row 3 beginning in column B. Prior
to entering January in cell B3 and using the AutoFill handle (as described in
Chapter 2) to fill in the 11 months across row 3, you select all three worksheets
(Sheet1, Sheet2, and Sheet3, for argument’s sake). When you enter the names
of the months in the third row of the first sheet, Excel will insert the names of
the months in row 3 of all three selected worksheets. (Pretty slick, huh?)