Microsoft Office Tutorials and References
In Depth Information
Navigating Sheets in a Workbook
Navigating Sheets in a Workbook
As you know, a single workbook can contain multiple worksheets. The sheet tabs at the bottom
of the Excel window identify the worksheets. Click a sheet tab, and that sheet becomes the active
sheet. If the tab for the sheet you want isn’t visible, you can use the tab scroll controls to the left
of the first sheet tab to scroll the tabs left or right (see Figure 8-1).
Figure 8-1: Use these controls to scroll the sheet tabs to the left or right.
The sheet tabs share space with the horizontal scroll bar. You can reduce the width of the
horizontal scroll bar to reveal more sheet tabs. Just click the vertical bar on the left side of the scroll
bar and drag it to the right.
Another way to activate a sheet is to right-click the tab scroll controls. This action displays a
popup list of sheet names (see Figure 8-2). Just click a name, and you’re there. If not all the sheet
names are listed, click the More Sheets item at the bottom, and a dialog box that lists the sheet
names appears. Just double-click a sheet name to activate that sheet.
Figure 8-2: Right-clicking the tab scroll controls displays a list of sheet names.
In many cases, the most efficient way to activate a different sheet is to avoid the mouse and use
the keyboard. Surprisingly, many users don’t know about two useful keyboard commands:
h Ctrl+PgDn: Activates the next sheet
h Ctrl+PgUp: Activates the previous sheet
I use these keys 90 percent of the time — but then again, I avoid using a mouse whenever I can.
Search JabSto ::

Custom Search