Excel New Sheet Shortcut: Add a Worksheet in Seconds

In Excel for Microsoft 365 on Windows, press Shift+F11 to insert a new worksheet. The new sheet is placed immediately before the active sheet, so check which tab is selected if the sheet’s position matters.

The shortcut and what it does

Shift+F11 is the direct keyboard shortcut for adding a worksheet to the current workbook. It creates a blank sheet; it does not open a new workbook or duplicate the contents of an existing tab. The new worksheet becomes active, ready for you to enter data, paste content, or rename it.

An alternative Windows shortcut is Alt+Shift+F1. It also inserts a worksheet. You do not need to use both shortcuts; Shift+F11 is usually the easier one to remember. If your keyboard has a function-key mode that assigns special actions to F11, you may need to hold the Fn key as well—for example, Fn+Shift+F11.

Shift+F11: insert a worksheet before the active sheet.
Alt+Shift+F1: another shortcut for inserting a worksheet.
Ctrl+N: create a new workbook, not a new sheet in the current workbook.

Where the new worksheet appears

The shortcut inserts the sheet before the currently selected worksheet in the tab order. For example, if your tabs are January, February, and March, and February is active, pressing Shift+F11 inserts a new sheet immediately before February. Excel activates the new sheet, so its tab is selected after the shortcut runs.

This placement can be helpful when you want a new tab beside related sheets, but it can surprise you if you expect the new tab at the end. If you need it elsewhere, drag the new sheet’s tab to the desired position. You can also select a particular existing tab before using the shortcut to control where the new sheet is inserted. In a workbook with many tabs, use the sheet-navigation arrows at the bottom left to reach the relevant tab before adding one.

Adding a sheet with the mouse or ribbon

If you do not want to use a keyboard shortcut, click the New Sheet button, shown as a plus sign beside the worksheet tabs. It creates a worksheet in the current workbook. This is convenient when your hands are already on the mouse or when a function key is difficult to reach.

You can also use the ribbon: go to Home > Insert > Insert Sheet. Another option is to right-click a worksheet tab, choose Insert, select Worksheet if the Insert dialog asks what to add, and confirm. The ribbon command and the shortcut both add a blank worksheet; neither copies the selected sheet’s data or formatting.

For frequent use, the plus button is easy to spot, while Shift+F11 is usually faster once it becomes familiar. The right-click menu is useful when you are already managing tabs, because it also offers related commands such as deleting, renaming, moving, or copying a worksheet.

Using the shortcut on Mac and Excel for the web

In Excel for Mac, Shift+F11 is also the worksheet-insertion shortcut. On some Mac keyboards, the function keys control hardware features by default. If pressing the combination changes a system setting or does not insert a sheet, try Fn+Shift+F11, or adjust the keyboard’s function-key behavior in macOS settings. You can always use the New Sheet plus button or the Insert command if the key combination is intercepted.

Excel for the web can be used with a keyboard, but browser and operating-system shortcuts may affect which combinations are available. If Shift+F11 does not add a sheet in your browser, click the plus sign by the sheet tabs. The ribbon’s Home > Insert > Insert Sheet command is another option. A shortcut that works in the desktop app is not guaranteed to behave identically in every browser setup.

On both platforms, make sure the workbook itself is open and that you are not typing inside a cell or editing a formula. Finish the cell edit first by pressing Enter or Esc, then try the shortcut again.

Choose the right command for the task

Several Excel actions sound similar but have different results. Choosing the right one prevents you from creating a separate file when you meant to add a tab, or making an empty sheet when you wanted a copy.

Add a blank worksheet: press Shift+F11 on Windows or Mac, or use the New Sheet button.
Make a separate workbook: press Ctrl+N on Windows. On Mac, use Command+N. This creates a new workbook rather than a tab in the current one.
Copy an existing worksheet: right-click its tab and choose Move or Copy, then select Create a copy. This retains the sheet’s contents and formatting.
Switch between worksheets: use Ctrl+Page Up or Ctrl+Page Down on Windows to move between tabs. These navigate existing sheets; they do not create one.

As an example, if you have a sales workbook with one sheet per region and need a blank tab for a new region, Shift+F11 is appropriate. If you need a new version of the current region sheet with its formulas and layout intact, copy the worksheet instead.

Common shortcut problems and fixes

If Shift+F11 appears to do nothing, first check whether Excel is in cell-edit mode. A blinking insertion point in a cell or the formula bar means Excel is editing text; press Enter to keep the edit or Esc to cancel it, then try again. Also confirm that you are in the Excel window rather than another application.

F11 triggers a device feature: try Fn+Shift+F11. Laptop function-key behavior varies by model and system settings.
The workbook structure is protected: a protected workbook structure can prevent users from inserting, deleting, moving, or renaming sheets. If you are authorized, use Review > Protect Workbook to check the structure protection and unprotect it with the required password.
The sheet is created in an unexpected place: the active worksheet determines where Shift+F11 inserts it. Select the intended neighboring tab first, or drag the new tab afterward.
The shortcut is intercepted: use the plus button or the ribbon command. This is common on laptops, in browsers, or when keyboard settings assign special behavior to function keys.

If you are working in a shared or managed file, do not try to bypass protection. Ask the workbook owner or administrator to grant the required permission. Excel may also restrict changes when a file is opened in a read-only state or when editing is disabled; check the message bar and file permissions before assuming the shortcut itself is broken.

What to do after inserting a sheet

Excel assigns a default name such as Sheet4. To give the new tab a useful label, double-click its tab, type a name, and press Enter. A clear name such as “2026 Budget” or “West Region” makes navigation easier than relying on numbered defaults. Worksheet names must be unique within a workbook, cannot be blank, and cannot contain the characters : \ / ? * [ ]. They are limited to 31 characters.

You can also apply a tab color by right-clicking the tab and choosing Tab Color. For a new sheet that should follow a particular template, copy the template sheet instead of inserting a blank one. Copying is important when the original includes formatting, formulas, print settings, or carefully arranged columns that a blank worksheet would not inherit.

Adding a worksheet does not automatically connect it to formulas on other sheets. If you intend to summarize the new tab elsewhere, you may need to update formulas, charts, or references. Review those links after renaming or moving sheets, especially in workbooks with reports that depend on specific sheet names.

Frequently Asked Questions

What is the shortcut to create a new sheet in Excel?
In Excel for Microsoft 365 on Windows, press Shift+F11. The shortcut inserts a blank worksheet before the active sheet. Alt+Shift+F1 is another Windows shortcut for the same action.

Does Ctrl+N add a new sheet in Excel?
No. Ctrl+N creates a new workbook. To add a worksheet to the workbook you already have open, use Shift+F11 or click the plus button beside the sheet tabs.

How do I add a new sheet at the end of my tabs?
Shift+F11 inserts before the active sheet, not necessarily at the end. Click the New Sheet plus button and check the resulting tab position, or insert a sheet near a chosen tab and drag it to the end.

Why does Shift+F11 not work on my laptop?
Your keyboard may require the Fn key for function-key commands, or Excel may be editing a cell. Try Fn+Shift+F11, finish or cancel any cell edit, or use the New Sheet button instead.

How do I add a new sheet in Excel for Mac?
Try Shift+F11. If your Mac uses the function keys for system controls, try Fn+Shift+F11. The plus button beside the worksheet tabs is a reliable alternative.

How can I create a copy instead of a blank sheet?
Right-click the worksheet tab you want to duplicate, choose Move or Copy, select Create a copy, and confirm where to place it. That creates a sheet with the original’s contents rather than an empty worksheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.