Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
Here are some tips on how to move back and
forth between worksheets:
Normally, a workbook contains three worksheets,
although you can set up Excel so that new
workbooks contain a different number of starting
sheets. In any case, it’s a simple matter to add
worksheets to a workbook. You might want to
use worksheets to separate similar, but different
data in a workbook. For example, you might use
separate worksheets, one for each month, to
enter budget, sales, or inventory data.
To change from one worksheet to another,
simply click its tab.
In workbooks with many worksheets, you
may not see all the tabs at one time. Use
the tab-scrolling buttons to adjust the tab
listing until the tab of the worksheet you
want to switch to is visible.
To display the first few worksheet tabs,
click the first tab-scrolling button.
To display the last few worksheet tabs,
click the last tab-scrolling button.
There are several ways to insert a worksheet into
a workbook. Use whichever of these methods
suits you best at the time:
To scroll the tab listing to the left or
right one worksheet at a time, click
one of the tab-scrolling buttons in the
Click the arrow on the Insert button on
the Home tab, and select Insert Sheet
from the menu that appears. A sheet is
inserted in front of the current sheet.
The newly inserted sheet becomes the
currently displayed sheet. See Figure 6-2.
Drag the tab split box to the right to
increase the number of worksheet tabs
displayed at any given time. (This will
shorten the horizontal scroll bar a bit, but
it will still be useable.) Drag the tab split
box to the left to decrease the number of
worksheet tabs displayed.
A new sheet is inserted in front of the current sheet.