How to Delete a Sheet in Excel | CustomGuide

How to Delete a Sheet in Excel

How to Insert, Rename, and Delete Worksheets in Excel

How to Delete a Sheet in Excel

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.

  1. Click the Insert button list arrow on the Home tab.
  2. Select Insert Sheet.
    Insert a Worksheet

    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.

  1. Click the Format button on the Home tab.
  2. Select Rename Sheet.

    Double-click the tab for the worksheet you want to rename.

  3. Type a new name for the worksheet.
    Rename a Worksheet
  4. Press Enter.

The worksheet is renamed.

Change Tab Color

You can also keep your worksheets a bit more organized by changing the tab color.

  1. Click the Format button on the Home tab.
  2. Select Tab Color.

    Right-click a sheet tab and select Tab Color.

  3. Select a tab color.
    Change 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.

  1. Click the Delete list arrow on the Home tab.
  2. Select Delete Sheet.
    Delete a Worksheet

    Right-click a sheet tab and select Delete Sheet.

  3. Click Delete in the confirmation dialog.

The worksheet is deleted.