
You can easily add worksheets to a workbook or delete unwanted ones. You can also rename a worksheet to accurately describe the data being presented.
Insert a Worksheet
You may need to add additional data to a workbook that belongs in a separate worksheet.
- Click the Insert button list arrow on the Home tab.
- Select Insert Sheet.
Click the New Sheet button at the bottom of the workbook window, to the right of the last sheet tab.
A new worksheet is added to the workbook.
Rename a Worksheet
By default, Excel worksheets are given generic names, such as Sheet 1, Sheet 2, etc. You can give them more meaningful names.
- Click the Format button on the Home tab.
- Select Rename Sheet.
Double-click the tab for the worksheet you want to rename.
- Type a new name for the worksheet.
- Press Enter.
The worksheet is renamed.
Change Tab Color
You can also keep your worksheets a bit more organized by changing the tab color.
- Click the Format button on the Home tab.
- Select Tab Color.
Right-click a sheet tab and select Tab Color.
- Select a tab color.
Now the tab is shaded with the color you chose.
Delete a Worksheet
If you no longer need a sheet, delete it from the workbook.
- Click the Delete list arrow on the Home tab.
- Select Delete Sheet.
Right-click a sheet tab and select Delete Sheet.
- Click Delete in the confirmation dialog.
The worksheet is deleted.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- Zoom in Excel
- How to Remove Gridlines in Excel
- How to Copy a Sheet in Excel