Microsoft Office Tutorials and References
In Depth Information
Naming and renaming worksheets
You cannot undo the insertion of a new worksheet. If you do need to delete a worksheet,
right-click its sheet tab and click Delete. If you want to delete more than one worksheet,
you can hold down Shift to select a range of worksheets, or you can hold down Ctrl and
select nonadjacent worksheets, before you click Delete.
CAUTION !
Be careful! You cannot retrieve a worksheet after you delete it.
Naming and renaming worksheets
Notice that Excel numbers the new worksheets based on the number of worksheets in
the workbook. If your workbook contains one worksheet, the first worksheet you insert is
Sheet2, the next is Sheet3, and so on. If you grow weary of seeing Sheet1, Sheet2, and so
on in your workbooks, you can give your worksheets more imaginative and helpful names
by double-clicking the tab and typing a new name.
You can use up to 31 characters in your worksheet names. Nevertheless, you should
remember that the name you use determines the width of the corresponding sheet tab, as
shown in Figure 6-15. Therefore, you might want to keep your worksheet names concise so
that you can see more than a couple of sheet tabs at a time.
Figure 6-15 Double-click the sheet tab to type a new name. You might want to keep it short.
Moving and copying worksheets
As you might expect, Excel provides an easy way to move a worksheet from one place to
another in the same workbook. In fact, all you have to do is click a sheet tab to select it and
then drag it to its new location. Figure 6-16 shows this process. When you drag a
worksheet, a small worksheet icon appears, and a tiny arrow indicates where the worksheet will
be inserted in the tab order.
Search JabSto ::




Custom Search