CTM Work with Sheet Tabs

For All Your Training Needs [ Home ] [ Up ] [ Site Map ] [ Search ]

Microsoft Excel
Work with Sheet Tabs

Description

Each new Microsoft Excel workbook starts with 3 sheet tabs, named Sheet1, Sheet2 and Sheet3. You can easily add, delete, rename, color and move or copy the sheet tabs using the steps listed below.

Sheet Tabs

Add New Sheet Tabs

Right-click an existing sheet tab
- The new sheet tab will be inserted to the left of the selected sheet tab
Select the Insert command from the shortcut menu
Insert Dialog Box
- If necessary, click the General tab
- Select the Worksheet icon
- Click the OK button
NOTE: the number of sheets that you can create is limited by the amount of available computer memory

Sheet Tab Shortcut Menu

Delete Sheet Tabs

Right-click the sheet tab you want to delete
Select the Delete command from the shortcut menu
- Excel 2002 (XP) and 2003 will delete the sheet tab
- Excel 97 and 2000 will display a prompt asking if you are sure you want to delete

Rename a Sheet Tab

Right-click the sheet tab you want to rename
Select the Rename command from the shortcut menu
Type the new name then depress the <Enter> key

Color the Sheet Tabs - Excel 2002 (XP) and 2003 only

Right-click the sheet tab you want to color
Select the Tab Color command from the shortcut menu
Format Tab Color Dialog Box
- Click to select a color from the palette
- Click the OK button

Renamed & Colored Sheet Tabs

Move or Copy Sheet Tabs

Right-click a sheet tab
Select the Move or Copy command from the shortcut menu
Move or Copy Dialog Box
- To move or copy to a different workbook, select the workbook in the To Book list
  - The other workbook must be opened for it to appear in the list
- To move or copy to a spot in the same workbook, select a sheet in the Before Sheet box
- To copy the selected sheet tab, turn on the Create a Copy option
- Click the OK button

Move or Copy Dialog Box

Microsoft Excel Work with Sheet Tabs