Microsoft Office Tutorials and References
In Depth Information
Deleting, Copying, and Moving Data
Follow these instructions to move among, add, delete, rename, and change
the order of worksheets:
✦ Inserting a new worksheet: Click the New Sheet button (you can find it
in the lower-left corner of the screen to the right of the worksheet tab);
press Shift+F11; or on the Home tab, open the drop-down list on the
Insert button and choose Insert Sheet.
✦ Moving among worksheets: To go from one worksheet to another, click
a worksheet tab along the bottom of the screen. If you can’t see a tab,
click one of the scroll arrows to the left of the worksheet tabs.
✦ Renaming a worksheet: Right-click the worksheet tab, choose Rename
on the shortcut menu, type a new name, and press Enter. You can also
go to the Home tab, click the Format button, choose Rename Sheet on
the drop-down list, and enter a new name. Spaces are allowed in names,
and names can be 31 characters long. Brackets () are allowed in
names, but you can’t use these symbols: / \ : ? and * .
✦ Selecting worksheets: Click the worksheet’s tab to select it. To select
several worksheets, Ctrl+click their tabs or click the first tab and then
Shift+click the last tab in the set. To select all the worksheets, right-click
a tab and choose Select All Sheets on the shortcut menu.
✦ Rearranging worksheets: Drag the worksheet tab to a new location. As
you drag, a tiny black arrow and a page icon appear to show you where
the worksheet will land after you release the mouse button. You can also
select a sheet, go to the Home tab, click the Format button, and choose
Move or Copy Sheet on the drop-down list. The Move or Copy dialog box
appears, as shown in Figure 2-4. Select the sheet in the Before Sheet list
where you want the worksheet to go and click OK.