Microsoft Office Tutorials and References
In Depth Information
Using the workbook window
Workbook navigation tips
Many features and controls can help you navigate through the rows, columns, and
worksheets in a workbook. Here are the highlights:
Use the sheet tab navigation buttons to view all the sheet tabs in your workbook;
click a tab to view the contents of that worksheet.
Drag the tab split handle to the right if you want to see more sheet tabs at the
expense of the horizontal scroll bar’s width. To return to the usual tab display,
double-click the tab split handle.
Press Ctrl+Page Down to activate the next worksheet in the workbook; press
Ctrl+Page Up to activate the previous worksheet.
Press Ctrl+Home to jump to cell A1 from anywhere on a worksheet.
Right-click any scroll bar to display a shortcut menu dedicated to scrolling actions, as
shown in Figure 2-4.
Figure 2-4 Right-click a scroll bar to display a shortcut menu of navigational commands.
● Drag the scroll box (also known as the scroll thumb ) to move around the worksheet.
Click the scroll bar anywhere outside the scroll box to move one screen at a time in
the direction in which you clicked.
The size of the scroll box changes depending on the size of the scrollable area. For
example, the scroll boxes shown in Figure 2-4 are more than half as large as the
scroll bars themselves, indicating there is little more to see in the active area of the
worksheet—nothing, in fact, because this is a blank worksheet. As you add data to
more columns and rows than can appear on a single screen, the scroll boxes get