Datasheet

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. All Excel users know that they can
activate a different sheet by clicking its sheet tab. 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 7-1).
Figure 7-1: Use these controls to scroll the sheet tabs to the left or right.
You can also 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
pop-up list of sheet names (see Figure 7-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 7-2: Right-clicking the tab scroll controls displays a list of sheet names.
Tip 7: Navigating Sheets in a Workbook
26
04_137666 ch01.qxp 5/22/07 7:31 PM Page 26