While working in Excel, users often need to add a new worksheet or delete an existing one in the current workbook. In this tutorial, we will show you how to add. We have some quick and simple methods for this.
Add a Worksheet using the 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:
- First, click on the worksheet tab to the left to which you want to add a new worksheet.
- After that, go to the “Home” tab and click on the “Insert” icon drop-down under the “Cells” group on the ribbon.
- Now, select the “Insert Sheet” option from the drop-down list.
- 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
- First, right-click on the worksheet tab to the left of which you want to insert a new worksheet.
- After that, click on the “Insert” option from the list.
- Once you click on the “Insert” option you will get a new “Insert” dialog box opened.
- Now, select “Worksheet” and click OK.
- At this point, you will get your new worksheet (Sheet3) inserted to the left of the “Mar_22” worksheet.
Using the above steps, you can add multiple worksheets at once by selecting the existing worksheets. Excel will add the same number of new worksheets you currently have selected.
Keyboard Shortcut
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 add the new worksheet to the right of the selected worksheet tab, but in this case, you cannot add multiple worksheets simultaneously.
- First, select the worksheet tab to the right to which you want to add a new worksheet.
- 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.
Thank you for this article.