How to 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.

In this tutorial, we will show you how to add or delete a worksheet. We have some quick and simple methods for this.

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.
   
4. At this point, you will get your new worksheet (Sheet2) inserted to the left of the “Mar_22” worksheet.
   

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. Once you click on the “Insert” option you will get a new “Insert” dialog box opened.
4. Now, select “Worksheet” and click OK.
   
5. At this point, you will get your new worksheet (Sheet3) inserted to the left of the “Mar_22” worksheet.
   

Using the above same steps, you can also add multiple worksheets at once by selecting the multiple existing worksheets. 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

With the (+) button you can also add the new worksheet to the right of the selected worksheet tab, but in this case, you cannot add multiple worksheets at once. You can only add one new worksheet.

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 (+) button on the tab bar and you will get a new worksheet added to the right of the selected worksheet.

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.
   
4. At this point, you will find your selected worksheet(s) deleted from the current workbook.
   

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.