Deleting or Inserting a Blank Worksheet

   Overview   

You can delete unnecessary worksheets from a workbook or insert new blank worksheets.

   Instructions   

  1. Step 1: In an Excel workbook, right-click the tab for the sheet that you want to delete.
  2. Step 2: To remove the selected worksheet, click the Delete option.
  3. Step 3: To confirm the removal of the selected sheet, click the Delete button.
  4. Step 4: The selected sheet has been deleted from the workbook.
  5. Step 5: To insert a new sheet into the workbook, right-click a tab for a sheet.
  6. Step 6: From the pop-up menu, click the Insert... option.
  7. Step 7: From the General tab, select the appropriate worksheet you wish to insert into your workbook.  
  8. Step 8: Click the OK button.
  9. Step 9: The selected sheet has been added to the Workbook.

In this article, you will learn the steps to delete and insert a blank worksheet into an Excel Workbook.

1. Step 1

step image

In an Excel workbook, right-click the tab for the sheet that you want to delete.

Example shown here: Right-click the sheet 1 (2) tab.

2. Step 2

step image

A pop-up menu is displayed.

To remove the selected worksheet, click the Delete option.

3. Step 3

step image

To confirm the removal of the selected sheet, click the Delete button.

4. Step 4

step image

The selected sheet has been deleted from the workbook.

5. Step 5

step image

To insert a new sheet into the workbook, right-click a tab for a sheet.

Right-click the sheet 1 tab.

6. Step 6

step image

From the pop-up menu, click the Insert... option.

7. Step 7

step image

The Insert pop-up menu is displayed.

From the General tab, select the appropriate worksheet you wish to insert into your workbook.  

Example shown here: Click the Worksheet option.

8. Step 8

step image

Click the OK button.

9. Step 9

step image

The selected sheet has been added to the Workbook.  

Print Article

Details

Article ID: 150169
Created
Sat 9/24/22 11:35 PM
Modified
Fri 1/5/24 5:12 PM