Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Maintaining Multiple Worksheets
To go from one worksheet to another, you simply click the tab that contains
the name of the sheet you want to see. Excel then brings that worksheet
to the top of the stack, displaying its information in the current workbook
window. You can always tell which worksheet is current because its name
is in bold type on the tab and its tab appears as an extension of the current
worksheet with a bold line appearing along the bottom edge.
The only problem with moving to a new sheet by clicking its sheet tab occurs
when you add so many worksheets to a workbook (as I describe in the
upcoming section “Don’t Short-Sheet Me!”) that not all the sheet tabs are
visible at any one time, and the sheet tab you want to click is not visible in the
workbook indicated on the Status bar by an ellipsis (three periods in a row)
that appears immediately after the last visible sheet tab.
To deal with the problem of not having all the sheet tabs visible, Excel
provides two tab scrolling buttons on the Status bar before the first sheet tab
that you can use to bring new sheet tabs into view:
✓ Click the Next tab scroll button (with the triangle pointing right) to bring
the next unseen tab of the sheet on the right into view. Hold down the
Shift key while you click this button to scroll several tabs at a time. Hold
down the Ctrl key while you click this button to bring the last group of
sheets, including the last sheet tab into view.
✓ Click the Previous tab scroll button (with the triangle pointing left) to
bring the next unseen tab of the sheet on the left into view. Hold down
the Shift key while you click this button to scroll several tabs at a time.
Hold down the Ctrl key when you click this button to bring the first
group of sheet tabs, including the very first tab, into view.
✓ Right-click either tab scroll button to open the Activate dialog box
(shown in Figure 7-1) showing a list of all the worksheets — to activate a
worksheet in this list, select it followed by OK.
a tab scroll
with a list
of all the