Datasheet

Move Around in a Workbook
Move Around
in a Workbook
Y
ou can move between the worksheets in a
workbook using the tabs and controls at the
bottom of the Excel screen. By default, a
workbook contains at least three worksheets and you
can switch between them. If your workbook contains
more than three worksheets, it is possible that the tabs
for all worksheets will not be visible at all times. You
can use the controls to the left of the worksheet tabs
to scroll through hidden worksheets. The first and last
controls scroll all of the worksheet tabs to display the
first and last worksheets, respectively. The middle
controls scroll to display the next worksheet tab in the
direction of the control’s arrow.
•
•
2
•
1 Open a workbook.
•
Excel displays the first worksheet in the
workbook or the last sheet you viewed
before saving the workbook.
2 Click a worksheet tab.
•
Excel displays that worksheet.
•
To display additional worksheet tabs, you
can click these controls.
18
How can I make more worksheet tabs
visible at all times?
Resize the horizontal scroll bar by moving
the mouse pointer over the left edge of
the horizontal scroll bar. When the resizing
mouse pointer ( ) appears, click and
drag to the right. Excel makes more space
available for worksheet tabs and less for
the horizontal scroll bar.
05_181706 ch01.qxp 1/31/08 9:44 PM Page 18