Add and Delete a Worksheet in Excel

While working in Excel many times users need to add a new worksheet or delete an existing worksheet in the current workbook.

So, in this tutorial, we will show you how to add or delete a worksheet. We have some quick and simple steps mentioned below for you to add or delete a worksheet.

Add a Worksheet Using Home Tab

Using the Home tab, you can add the worksheet to the left of the selected worksheet and for this, you must follow the steps below:

  1. First, click on the worksheet tab to the left to which you want to add a new worksheet.
  2. After that, go to the “Home” tab and click on the “Insert” icon drop-down under the “Cells” group on the ribbon.
  3. Now, select the “Insert Sheet” option from the drop-down list.
    1-insert-sheet-using-home-tab
  4. At this point, you will get your new worksheet (Sheet2) inserted to the left of the “Mar_22” worksheet.
    2-new-sheet-inserted

Add a Worksheet using Right Click Option

  1. First, right-click on the worksheet tab to the left of which you want to insert a new worksheet.
  2. After that, click on the “Insert” option from the list.
    3-insert-sheet-using-right-click
  3. Once you click on the “Insert” option you will get a new “Insert” dialog box opened.
  4. Now, select “Worksheet” and click OK.
    4-select-worksheet
  5. At this point, you will get your new worksheet (Sheet3) inserted to the left of the “Mar_22” worksheet.
    5-new-sheet-inserted-to-the-left

Users can also add multiple worksheets at once by selecting the multiple existing worksheets and then by doing the above steps, Excel will add the same number of new worksheets you currently have selected.

You can also add a new workbook to the left of the selected worksheet using the shortcut key Shift + F11.

Add a Worksheet to the right Using Plus (+) Sign

In Excel, we can also add the new worksheet to the right of the selected worksheet tab but in this case, we cannot add multiple new worksheets at once even after selecting the multiple tabs. We can only add one new worksheet at once.

  1. First, select the worksheet tab to the right to which you want to add a new worksheet.
  2. After that click on the plus (+) sign on the tab bar and you will get a new worksheet added to the right of the selected worksheet.
add-worksheet-to-the-right

Delete a Worksheet Using Home Tab

Users can delete single or multiple worksheets at once in Excel and for this follow the steps below:

  1. First, click on the worksheet tab or select the multiple worksheet tabs in case to delete multiple worksheets.
  2. After that, go to the “Home” tab and click on the “Delete” icon drop-down under the “Cells” group on the ribbon.
  3. Now, select the “Delete Sheet” option from the drop-down list.
    7-delete-worksheet-using-home-tab
  4. At this point, you will find your selected worksheet(s) deleted from the current workbook.
    8-worksheet-deleted1

Delete a Worksheet Using Right Click Option

  1. First, right-click on the worksheet tab and click on the “Delete” option from the list.
  2. To delete multiple worksheets, select the multiple worksheets and then right-click and click on the “Delete” option.
delete-a-worksheet-using-right-click

Leave a Comment