Microsoft Office Tutorials and References
In Depth Information
Naming and Rearranging Worksheets
Worksheets and
Workbooks
Figure 15-18:
This workbook contains two hidden worksheets. To restore one,
just select it from the list, and then click OK. Unfortunately, if you
want to show multiple hidden sheets, you must use the Unhide
Sheet command multiple times. Excel has no shortcut for unhiding
multiple sheets at once.
Naming and Rearranging Worksheets
The standard names Excel assigns to new worksheets—Sheet1, Sheet2, Sheet3, and so
on—aren’t very helpful for identifying what they contain. And they become even less
helpful if you start adding new worksheets, since the new sheet numbers don’t
necessarily indicate the position of the sheets, just the order in which you created them.
For example, if you’re on Sheet 3 and you add a new worksheet (by choosing
Home Cells Insert Insert Sheet), then the worksheet tabs read: Sheet1, Sheet2,
Sheet4, Sheet3. (That’s because the Insert Sheet command inserts the new sheet just
before your current sheet.) Excel doesn’t expect you to stick with these auto-gener-
ated names. Instead, you can rename them by right-clicking the worksheet tab and
selecting Rename, or just double-click the sheet name. Either way, Excel highlights
the worksheet tab, and you can type a new name directly onto the tab. Figure 15-19
shows worksheet tabs with better names.
Figure 15-19:
Worksheet names can be up to 31 characters long
and can include letters, numbers, some symbols,
and spaces. Remember, though, the longer the
worksheet name, the fewer worksheet tabs you’ll
be able to see at once, and the more you’ll need
to rely on the scroll buttons to the left of the
worksheet tabs. For convenience’s sake, try to
keep your names brief by using titles like Sales04,
Purchases, and Jet_Mileage.
Note: Excel has a small set of reserved names that you can never use. To witness this problem, try to
create a worksheet named History. Excel doesn’t let you because it uses the History worksheet as part of
its change tracking features. Use this Excel oddity to impress your friends.
 
Search JabSto ::




Custom Search