Sometimes users need to add or delete worksheets within the workbook while working in Excel. In this post, we will check how to add and delete worksheets in Excel.
There are so many ways to add and delete the worksheets in Excel and will check them one by one.
Video Tutorial:
Add a Worksheet using the Worksheet tab:
You can only add one worksheet at a time using the worksheet tab but you can’t add multiple worksheets all at once.
- Go to the worksheet tab in the Excel workbook.
- Locate the “Insert Worksheet (+)” button and click on it.
- Now a new worksheet will be added to your workbook.
In the same way, you can create worksheets one by one.
Add a Worksheet using the Home tab:
- First, go to any existing worksheet.
- Navigate to the Home tab on the Excel Ribbon.
- Click on the Insert drop-down button in the cells group.
- Now Select Insert sheet.
- A new worksheet will be inserted beside the current active worksheet.
Using the Home tab you can add multiple worksheets in one go. If you want to add 2 worksheets, select 2 already available worksheets in Excel and follow the above steps. Now another 2 worksheets will be added to your workbook.
Add a Worksheet using the shortcut:
Using Keyboard shortcuts in Excel will save you a lot of time. First, go to any worksheet.
- Now click on Shift + F11.
- A new worksheet will be created beside the selected worksheet.
Using this shortcut, you can add multiple worksheets in one go. Select worksheets and press Shift + F11.
Delete a Worksheet using the Worksheet tab:
- Go to the worksheet tab.
- Right-click on the worksheet you want to delete.
- Select the “Delete” option from the context menu.
- The selected worksheet will be removed from the workbook.
If you want to delete multiple worksheets, simply select the worksheets you want to remove, then right-click on any of the selected worksheets and choose the delete option. Now selected worksheets will be deleted from the Workbook.
Delete a Worksheet using the Home tab:
- First, go to any worksheet.
- Navigate to the Home tab and click on the Delete drop-down button.
- Now click on the Delete sheet. Now selected worksheet will be deleted from your workbook.
If you want to delete multiple worksheets, simply select the worksheets and follow the above steps.
Managing worksheets in Excel doesn’t need to feel overwhelming. With these simple methods, you can easily add or delete worksheets in Excel easily. The next time when you’re working in Excel, do try these techniques.