Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
Managing Large Amounts of Data
Insert Worksheet tab
Another way to delete a worksheet is to
right-click the worksheet tab and choose
Delete from the resulting shortcut menu.
Because Excel uses the rather generic naming
scheme of Sheet1 or Sheet2, you can more easily
identify the type of data each worksheet contains if
you give your worksheets more descriptive names.
Names for sheets can be up to 31 characters long
and are not case sensitive; however, a worksheet
name cannot be left blank and cannot include
these special characters: – * / \ ? : [ ]. Just follow
these steps to rename a worksheet:
Inserting a new worksheet.
If you have created a worksheet in an Excel file
that you no longer need, you can delete it.
Deleting unnecessary worksheets can save on file
size and make the file quicker to open and close.
Click anywhere on the sheet you want to
Choose Home>Cells>Delete (arrow)>Delete Sheet.
If any cells in the selected sheet have data in
them, a warning message appears, as shown in
Figure 11-2. However, a worksheet with no data in
it will not display the warning message. Click the
Delete button. Use caution when deleting
worksheets. The Undo feature does not work with the
Delete Sheet function.
2. Choose Home>Cells>Format>Rename Sheet.
The worksheet tab becomes highlighted.
Leave it highlighted so that you can replace
it with a new name.
Right-Click Worksheet Tab
Optionally, right-click the worksheet tab and
Deleting a worksheet.
3. Type a unique name for the worksheet, as
shown in Figure 11-3. Remember that two
worksheets in a single workbook cannot have
the same exact name.