This lesson teaches you how to add worksheets to and delete worksheets from workbooks. You will also learn how to copy, move, and rename worksheets.
By default, each workbook consists of 16 worksheet pages whose names appear on tabs near the bottom of the screen. You can insert new worksheet pages or delete worksheet pages as desired. One advantage to having multiple worksheet pages is that you can copy and move worksheets within a workbook or from one workbook to another. Another advantage is that you can keep separate pages of data more organized. Before we get into the details of inserting, deleting, and copying worksheets, you should know how to select one or more worksheets. Here's what you need to know:
To insert a new worksheet in a workbook, perform the following steps:
Figure 7.1
Excel inserts the new worksheet before the worksheet you selected.
Timesaver Tip: Shortcut Menu A faster way to work with worksheets is to right-click on the worksheet tab. This brings up a shortcut menu that lets you insert, delete, rename, move, copy, or select all worksheets. When you choose Insert from the shortcut menu, Excel displays the Insert dialog box. Click the Worksheet icon and click OK to insert a new worksheet.
If you plan on using only one worksheet, you can remove the 15 other worksheets to free up memory. Here's how you remove a worksheet:
You can move or copy worksheets within a workbook or from one workbook to another. Here's how:
Figure 7.2
The Move or Copy dialog box asks you where you want to copy or move a worksheet.
An easier way to copy or move worksheets within a workbook is to use the Drag & Drop feature. First, select the tab of the worksheet(s) you want to copy or move. Move the mouse pointer over one of the selected tabs, click and hold the mouse button, and drag the tab where you want it moved. To copy the worksheet, hold down the Ctrl key while dragging. When you release the mouse button, the worksheet is copied or moved.
You can also use the Drag & Drop feature to quickly copy or move worksheets between workbooks. First, open the workbooks you want to use for the copy or move. Choose Window Arrange and select the Tiled option. Click on OK to arrange the windows so that a small portion of each one appears on-screen. Select the tab of the worksheet(s) you want to copy or move. Move the mouse pointer over one of the selected tabs, click and hold the mouse button, and drag the tab where you want it moved. To copy the worksheet, hold down the Ctrl key while dragging. When you release the mouse button, the worksheet is copied or moved.
By default, all worksheets are named Sheet and are numbered starting with the number 1. So that you'll have a better idea of the information each sheet contains, you can change the names that appear on the tabs. Here's how you do it:
Figure 7.3
Excel lets you give your worksheets more meaningful names.
In this lesson, you learned how to insert, delete, move, copy, and rename worksheets.
In the next lesson, you will learn how to print your workbook.
© Copyright, Macmillan Computer Publishing. All rights reserved.