Microsoft Office Tutorials and References
In Depth Information
Adding and Removing Worksheets
Worksheets and
Workbooks
Excel keeps track of the active cell in each worksheet. That means if you’re in cell B9
in Sheet1, and then move to Sheet2, when you jump back to Sheet1 you’ll
automatically return to cell B9.
Adding and Removing Worksheets
When you start a fresh workbook in Excel, you automatically get three blank
worksheets in it. You can easily add more worksheets. Just click the Insert Worksheet
button, which appears immediately to the right of your last worksheet tab (Figure
15-16). You can also use the Home Cells Insert Insert Sheet command, which
works the same way but inserts a new worksheet immediately to the left of the
current worksheet. (Don’t panic: page 435 shows how you can rearrange worksheets
after the fact.)
Figure 15-16:
Every time you click the Insert
Worksheet button, Excel inserts a
new worksheet after your
existing worksheets and assigns it a
new name. For example, if you
start with the standard Sheet1,
Sheet2, and Sheet3 and click the
Insert Worksheet button, then
Excel adds a new worksheet
named—you guessed it—Sheet4.
Insert worksheet
If you continue adding worksheets, you’ll eventually find that all the worksheet tabs
won’t fit at the bottom of your workbook window. If you run out of space, you need
to use the scroll buttons (which are immediately to the left of the worksheet tabs) to
scroll through the list of worksheets. Figure 15-17 shows the scroll buttons.
Figure 15-17:
Using the scroll buttons, you can
move between worksheets one
at a time or jump straight to the
first or last tab. These scroll
buttons control only which tabs you
see—you still need to click the
appropriate tab to move to the
worksheet you want to work on.
Go to end of the list
Scroll forward
Scroll backward
Go to beginning of the list
Search JabSto ::




Custom Search