In an Excel workbook, you may need to add or remove a worksheet. A user needs to understand that a workbook contains multiple sheets in which data can be stored, organized, and manipulated. Through worksheets, you can easily manage to add data, calculate reports and insert visuals to explain well your dataset. Do you know how to insert a new worksheet in Excel?
Here comes the real thing, if the answer is no, don’t worry. This post will explain how easily you can add a new sheet to your Excel workbook by using some useful hacks. So, let’s start digging into these hacks:
How to Insert a New Worksheet in Excel with New Sheet Button?
Well, this method is purely the easiest way you can use to insert a new worksheet in Excel. In this method, you can use the New Sheet button given on the right side of the current sheet tabs.
For this, you can left-click on the plus button that can be seen on the right side of the sheet tabs. Once you click on it, a new blank sheet will instantly appear in front of you. That’s how speedily a new sheet is added to the workbook.
How to Insert a New Worksheet in Excel with Home Tab?
In this method, the Home tab is used to add the worksheet. The new sheet will be added to the left of the current sheet. Let’s follow the steps given below:
- Click on the worksheet tab to the left in which you want to add a new sheet.
- Now, open the Home tab and click on the Insert drop-down menu given under the Cells group.
- Click on the Insert Sheet option from the drop-down menu.
A new sheet named Sheet 2 will be added to the left of the currently selected sheet.
That’s it!
How to Insert a New Worksheet in Excel with Keyboard Shortcuts?
Keyboard shortcut lovers tend to find simple and quick ways to solve any query. For today’s query, you will get two different shortcut commands to insert a new sheet in an already existing workbook in Excel. Below is the shortcut command:
SHIFT + F11
Press and hold the SHIFT key from the keyboard and then press the F11 key.
A new sheet is added simply to your workbook.
The second shortcut command for adding a new sheet is:
ALT + SHIFT + F11
First press the ALT key.
While holding the ALT key, press the SHIFT key from the keyboard.
Now, click on the F11 key right when you are holding the both ALT + SHIFT keys.
Release the ALT and SHIFT keys now.
You will promptly see a new worksheet added to the current workbook.
All done!
How to Insert a New Worksheet in Excel with Right-Click Option?
- With right-click option, you can add a new sheet as well. For this, follow the complete steps given below:
- Right-click on the sheet tab in which you need to add a new sheet.
- Now, click on the Insert button given in the list.
- The insert dialog box will pop up right after you click on the Insert option.
- Choose the Worksheet option and click OK.
A new sheet named Sheet 3 will be added to your workbook along with other sheets to the left of the current sheet.
Not only one sheet, but you can also even add multiple sheets at once by using the above steps. You just need to select the multiple existing sheets and Excel will simply add the number of new sheets you have selected.
How to Insert a New Worksheet in Excel with Insert Dialog Box?
Another way of adding a sheet to the workbook is by using the Insert dialog box. Follow the steps given below:
- Right-click one of the sheets available in your workbook.
- Open the Insert menu.
- From the Insert dialog box, confirm Worksheet is selected.
- Press OK.
This method not only adds new sheets but you can avail of some other features as well. To add a Chart Sheet or a Macro Sheet, you can use this Insert dialog box.
Final Thoughts:
That’s it! Now, you have learned how you can easily add a new sheet in the workbook in Excel by using multiple approaches. The best method is the first one in which the New sheet button is used to add a new sheet, as this method is safe and quick. Don’t worry about the other methods; each one is effective and secure.
