Microsoft Office Tutorials and References
In Depth Information
Tip: If you have a huge number of worksheets and they don’t all fit in the strip of worksheet tabs, there’s
an easier way to jump around. Right-click the scroll buttons to pop up a list with all your worksheets. You
can then move to the worksheet you want by clicking it in the list.
Removing a worksheet is just as easy as adding one. Simply move to the worksheet
you want to get rid of, and then choose Home ➝ Cells ➝ Delete ➝ Delete Sheet (you
can also right-click a worksheet tab, and then choose Delete). Excel won’t complain if
you ask it to remove a blank worksheet, but if you try to remove a sheet that contains
any data, it presents a warning message asking for your confirmation. Also, if you’re
down to one last worksheet, Excel won’t let you remove it. Doing so would create a
tough existential dilemma for Excel—a workbook that holds no worksheets—so the
program prevents you from taking this step.
Warning: Be careful when deleting worksheets, as you can’t use Undo (Ctrl+Z) to reverse this change!
Excel starts you off with three worksheets for each workbook, but changing this
setting’s easy. You can configure Excel to start with fewer worksheets (as few as one),
or many more (up to 255). Select File ➝ Options, and then choose the General
section. Under the heading “When creating new workbooks” change the number in the
“Include this many sheets” box, and then click OK. This setting takes effect the next
time you create a new workbook.
Note: Although you’re limited to 255 sheets in a new workbook, Excel doesn’t limit how many
worksheets you can add after you’ve created a workbook. The only factor that ultimately limits the number
of worksheets your workbook can hold is your computer’s memory. However, modern-day PCs can easily
handle even the most ridiculously large, worksheet-stuffed workbook.
Deleting worksheets isn’t the only way to tidy up a workbook or get rid of
information you don’t want. You can also choose to hide a worksheet temporarily.
When you hide a worksheet, its tab disappears but the worksheet itself remains
part of your spreadsheet file, available whenever you choose to unhide it.
Hidden worksheets also don’t appear on printouts. To hide a worksheet, right-click
the worksheet tab, and then choose Hide. (Or, for a more long-winded approach,
choose Home ➝ Cells ➝ Format ➝ Hide & Unhide ➝ Hide Sheet.)
To redisplay a hidden worksheet, right-click any worksheet tab, and then choose
Unhide. The Unhide dialog box appears along with a list of all hidden sheets, as
shown in Figure 15-18. Select a sheet from the list, and then click OK to unhide
it. (Once again, the ribbon can get you the same window—just point yourself to
Home ➝ Cells ➝ Format ➝ Hide & Unhide ➝ Unhide Sheet.)