Press Shift + F11 to insert a new worksheet to the left of the active sheet, or click the + (New sheet) button after the last sheet tab to add one to the right of the active sheet.
From the ribbon, go to Home → Insert → Insert Sheet. Or right-click a sheet tab, choose Insert, pick Worksheet and click OK. Both put the new sheet to the left of the active one.
To add several sheets in one go, select that many existing tabs first (Shift-click neighbouring tabs, Ctrl-click others), then use Home → Insert → Insert Sheet or right-click → Insert. Excel adds as many new sheets as you selected.
Watch for the word Group next to the file name in the title bar after selecting several tabs. While sheets are grouped, anything you type or format lands on every one of them, so click a single tab, or right-click a tab and choose Ungroup Sheets, before you carry on.
Each new sheet takes the next unused number, such as Sheet4, wherever it lands; double-click the tab to rename it. To change how many sheets a new workbook opens with, go to File → Options → General and set Include this many sheets.
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 a new worksheet to your workbook. We have some quick and simple methods for this.
Insert a New 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:
- Go to the Home Tab: Once you have your workbook open, navigate to the “Home” tab in the Ribbon. The Ribbon is the toolbar located at the top of the Excel window. The “Home” tab is typically the first tab in the Ribbon and includes the most frequently used Excel options.
- Cells Group: In the “Home” tab, you will find groups such as Clipboard, Font, Alignment, and Cells. Look for the “Cells” group.
- Click on Insert: Within the “Cells” group, locate and click the “Insert” button. Upon clicking, a drop-down menu will appear with a set of insert options: Insert Cells, Insert Sheet Rows, Insert Sheet Columns, and Insert Sheet. Click “Insert Sheet”.
- Done: This will immediately add a new worksheet to your workbook before the active sheet. If the sheet (Mar_22) is active in your workbook, the new sheet will be inserted before the sheet (Mar_22).
Must Read – Unlock a Sheet with a Password (Without Password) / Refresh a Sheet (Worksheet) in Excel
Add a Worksheet using the Right-Click Option on the Sheet Tab
This method is especially beneficial if you’re working with multiple worksheets and need your new sheet placed in a specific location within the workbook.
Here’s a detailed step-by-step guide on how to do this:
- Sheet Tabs: Look at the worksheet tabs at the bottom of your Excel window. Each tab represents a worksheet in your workbook.
- Location to Insert the Sheet: Identify where you want to add the new worksheet. It will be added to the left of the worksheet tab that you right-click.
- Right-click on the Tab: Once you’ve decided on the location, right-click on the worksheet tab adjacent to where you want your new sheet to appear. When you right-click, a context menu pops up. Click “Insert” in this menu.
- Sheet Type: After clicking on the “Insert” option, a pop-up window will appear. This window provides various options for insertion, including a chart sheet, older macro sheets, and templates. But for our purpose, we want to insert a new worksheet. Make sure the “Worksheet” option is selected in this pop-up window. It’s usually the first option and is represented by an icon of a blank worksheet.
- Click OK: Once “Worksheet” is selected, click “OK”. This will close the pop-up window. Upon clicking “OK”, Excel will instantly add a new worksheet at your chosen location. You will see a new tab for this worksheet alongside your other worksheets at the bottom of the Excel window.
Using the above steps, you can add multiple worksheets at once by first selecting multiple existing worksheet tabs (hold Shift and click the tabs). This also works with the Home tab method.
Excel will add the same number of new worksheets you currently have selected.
Important Points
- System Memory and Performance: While Excel doesn’t set a fixed limit on the number of worksheets in a workbook, your system’s memory and performance capabilities may limit the number of worksheets you can add. Adding too many worksheets can slow down your system, so it’s important to understand the impact on the speed of workbook operations.
- Navigation: When you add multiple worksheets, ten or more, the navigation within the workbook becomes complicated, as you can’t see all the sheet tabs. You can consider splitting the workbook into two or three to make it easier to navigate the workbook.
Must Read – Consolidate Data from Multiple Worksheets / Rename Sheet in Excel / Group Worksheets in Excel / View Two Sheets Side by Side in Excel
Add a Worksheet with a Keyboard Shortcut
An alternative method for adding a new worksheet in Excel is to use a keyboard shortcut.
It is helpful if you prefer keyboard shortcuts over mouse clicks for quicker navigation.
For Windows users, the keyboard shortcut to insert a new worksheet is Shift + F11.
For Mac users, you’ll need to press Fn + Shift + F11.
After pressing these keys, a new worksheet will be instantly added to your workbook.
Just like the Home tab method, the shortcut adds the new worksheet to the left of the active sheet. On a Mac, you need the Fn key when the top row of keys is set to control brightness, volume and other Mac features.
There’s one more shortcut on Windows that does the same thing: Alt + Shift + F1.
Add a Worksheet to the Right using the Plus (+) Sign
When you look at the Sheet Tabs section, you can find a small plus (+) icon there (Microsoft calls it New Sheet), which allows you to insert a new worksheet instantly.
- First, select the worksheet tab after which you want to add a new worksheet.
- After that, click the plus (+) button on the tab bar, and a new worksheet will be added to the right of the selected one.
With this (+) button, you can add a new worksheet to the right of the selected worksheet tab, but you cannot add multiple worksheets simultaneously.
Add a Worksheet with VBA
If you add sheets as part of a macro, you can use the Worksheets.Add method. The code below adds a new worksheet after the last sheet in the workbook and names it “Summary”.
Sub AddSheetAtEnd()
' Add a new worksheet after the last sheet and name it
Dim ws As Worksheet
Set ws = Worksheets.Add(After:=Sheets(Sheets.Count))
ws.Name = "Summary"
End Sub
Without any argument, Worksheets.Add inserts the new sheet before the active sheet, just like Shift + F11. You can use Before or After to choose the position, and Count to add more than one sheet at once, like Worksheets.Add Count:=3. Make sure the name you give is not already used by another sheet in the workbook, or the code will stop with an error. Put this code in a standard module (Insert > Module in the Visual Basic Editor).
Change the Number of Sheets in a New Workbook
In the latest versions of Excel, a new workbook starts with one worksheet. If you always need more, you can change this default:
- First of all, go to File > Options.
- After that, in the General tab, find the “When creating new workbooks” section.
- Now, enter the number of sheets you want in the “Include this many sheets” box.
- In the end, click OK.
This setting only applies to the new workbooks you create from now on. It doesn’t change workbooks that are already open or saved.
Why You Can’t Add a Worksheet
If the Insert Sheet option is greyed out and the plus (+) icon doesn’t work, the workbook structure is most likely protected. When a workbook’s structure is protected, nobody can add, delete, move, hide or rename sheets.
To fix this, go to the Review tab and click Protect Workbook to turn off the protection. If the workbook was protected with a password, Excel will ask you for it.
Which Method to Use
- Plus (+) icon: The quickest way to add one sheet to the right of the active sheet. It also works in Excel for the web.
- Shift + F11: The fastest way if you prefer the keyboard. It adds the sheet to the left of the active sheet.
- Home tab or right-click Insert: Use these when you want to add several sheets at once, or insert a sheet from a template (right-click Insert only).
- VBA: Use this when adding sheets is part of a macro, or when you need to add and name many sheets in one go.
Thank you for this article.