Excel Shortcut for a New Sheet: Shift+F11

In Excel for Microsoft 365 on Windows, press Shift+F11 to insert a new worksheet in the current workbook. Excel places it immediately before the active sheet; on a Mac, use Shift+F11 too, adding the Fn key if your keyboard treats F11 as a system control.

The quick answer and what happens

Click a worksheet tab to make that sheet active, then press Shift+F11. Excel creates a blank worksheet and selects it, so you can start entering data right away. The shortcut adds a sheet to the workbook you already have open; it does not create a separate Excel file.

The new tab normally appears just to the left of the sheet that was active when you used the shortcut. For example, if the workbook has Summary, January, and February tabs, and February is active, Shift+F11 adds a blank sheet between January and February. The new tab receives a default name such as Sheet4, depending on the workbook’s existing sheet names.

If you want the new sheet at a different position, you can move its tab afterward. Click and drag the tab along the sheet-tab bar, or use the sheet-tab context menu to access move or copy options. The shortcut is most useful when you want a blank worksheet quickly and do not need to choose its position first.

Worksheet, sheet, and workbook: the distinction

People often say “new sheet” when they mean a new worksheet tab. In Excel, a workbook is the file, while worksheets are the individual tabs inside it. A workbook can contain multiple worksheets, each with its own grid of cells. Shift+F11 adds a worksheet to the open workbook, leaving the other sheets and the file itself in place.

That distinction matters when you are choosing a shortcut. To create another worksheet in the current file, use Shift+F11. To create a separate, new workbook, use Ctrl+N on Windows. Ctrl+N does not add a tab to the workbook you are currently editing; it opens a new workbook. If you are unsure which action you need, look at the sheet tabs: a new tab means a worksheet was added, while a separate workbook opens in its own Excel window or document view.

Other ways to insert a worksheet

The keyboard shortcut is not the only way to add a tab. Excel provides several alternatives, which can be more convenient when you are using a mouse or working in a version where function-key behavior is awkward:

Use the New Sheet button: click the plus sign beside the sheet tabs at the bottom of the Excel window. Excel creates and selects a worksheet, usually after the last tab.
Use the ribbon: select Home > Insert > Insert Sheet. This is useful if the sheet-tab bar is difficult to reach or hidden.
Use the sheet-tab menu: right-click an existing sheet tab, choose Insert, and select Worksheet in the dialog. This lets you insert a worksheet near a particular tab.
Copy an existing sheet: right-click its tab and choose Move or Copy, then select the option to create a copy. This is better than inserting a blank sheet when you need to reuse headings, formulas, formatting, or page setup.

These methods do not all place the new sheet in the same spot. The plus button typically adds one at the end of the tab sequence, whereas Shift+F11 inserts before the active sheet. If tab order matters, check where the sheet appeared before entering data.

Using Shift+F11 on Windows

In Excel for Microsoft 365 on Windows, the standard shortcut is Shift+F11. Another documented keyboard option is Alt+Shift+F1. Both insert a worksheet, so you can use whichever combination is easier on your keyboard. These are Excel shortcuts; they may not work the same way in other programs or in a browser window that has taken control of a key.

For a predictable result, first make sure Excel is active and a worksheet is selected. If you are typing inside a cell, press Enter to commit the entry or Esc to cancel it, then use the shortcut. When a cell is in edit mode, keystrokes can affect the cell’s contents rather than being treated as a sheet command.

Some compact keyboards require the Fn key to send function-key commands. If Shift+F11 does not insert a sheet, try Fn+Shift+F11, check whether your keyboard has an F Lock setting, or use the plus button. The exact behavior depends on the keyboard and its function-key configuration, not just on Excel.

Using the shortcut on a Mac or in Excel for the web

Excel for Mac also uses Shift+F11 to insert a worksheet. Mac keyboards may assign F11 to a system function such as changing volume or showing the desktop. If pressing Shift+F11 triggers a system action instead of adding a tab, hold Fn as well, or adjust the macOS keyboard setting for using F1, F2, and other keys as standard function keys. The setting’s wording and location can vary by macOS version and keyboard.

In Excel for the web, the most straightforward method is the plus sign next to the worksheet tabs. Browser and operating-system shortcuts can compete with function keys, and browser keyboard support can vary. If Shift+F11 does not add a sheet in the web app, use the plus button rather than assuming the workbook is broken. The web interface may also arrange ribbon commands differently from the desktop application.

Why the shortcut may not work

If Shift+F11 appears to do nothing, check the workbook and keyboard state before trying a different command. Common causes include:

Excel is not receiving the keystrokes: click inside the workbook, then try again. Another application, browser, or system function may be capturing F11.
The keyboard needs Fn: try Fn+Shift+F11, or use the on-screen plus button to avoid function-key settings.
A cell is being edited: finish or cancel the cell edit with Enter or Esc, then retry the shortcut.
The workbook structure is protected: protection of workbook structure can prevent users from adding, deleting, moving, or renaming sheets. If you have permission, check Review > Protect Workbook for the workbook-structure protection control. You may need the password or the workbook owner’s help to change it.
The file is in a restricted or unusual state: permissions, organizational policies, or an application-specific view may limit editing. Check whether you can make other changes, and try the ribbon or plus button to see whether Excel displays an explanatory message.

Do not confuse sheet protection with workbook-structure protection. Protecting a worksheet generally restricts changes to cells on that sheet; protecting the workbook structure restricts changes to the collection of sheets, such as adding or moving tabs. The latter is the setting relevant to inserting a worksheet.

Choosing between a blank sheet and a copy

Shift+F11 is best when you want a fresh grid. It does not copy the active sheet’s cell contents, formatting, formulas, charts, print settings, or layout. If the new worksheet should follow the same monthly-report template as an existing tab, copying that template is usually a better choice than inserting a blank sheet and rebuilding it.

For example, imagine a workbook with a formatted April report containing headings, totals, and a chart. Pressing Shift+F11 gives you an empty sheet, not a May report. Use Move or Copy to duplicate April, then rename the copy and update its data. Conversely, if May needs a different layout, a blank worksheet avoids carrying over old formulas or formatting by accident.

After inserting a sheet, rename it with a specific label such as May or Inventory rather than leaving a generic name. Double-click the tab name, type the replacement, and press Enter. Clear names make formulas, navigation, and collaboration easier, especially in workbooks with many tabs.

Useful follow-up shortcuts and sheet organization

Once you have several worksheets, moving among them is often as useful as adding one. On Windows, Ctrl+Page Down moves to the next worksheet and Ctrl+Page Up moves to the previous one. These shortcuts change the active tab; they do not create, delete, or rearrange sheets. On Mac, the equivalent key combinations can differ with the keyboard and Excel configuration, so the sheet-tab navigation controls are a dependable alternative.

A simple workflow for a workbook with one tab per reporting period might be:

Select the tab that should sit immediately to the right of the new sheet.
Press Shift+F11 to insert a blank worksheet before that active tab.
Rename the new tab with the relevant period or subject.
Enter or paste the new data, then check formulas and references that should include the added sheet.

Inserting a worksheet does not automatically create a complete reporting system. Formulas that refer to specific sheets may not include the new one unless you update them, and charts or summaries may still point only to their original source ranges. After adding a tab to a workbook used for reporting, review the workbook’s links, totals, and presentation rather than assuming they expanded automatically.

Frequently Asked Questions

What is the shortcut to add a new sheet in Excel?
In Excel for Microsoft 365 on Windows, press Shift+F11. Alt+Shift+F1 is another keyboard shortcut for inserting a worksheet. On Mac, Shift+F11 works, sometimes with Fn as well.

Does Shift+F11 create a new workbook?
No. It adds a worksheet tab to the workbook that is already open. Use Ctrl+N on Windows when you want a separate new workbook.

Where does Excel put the new worksheet?
Shift+F11 inserts the worksheet before the currently active sheet. The plus button normally adds a sheet at the end of the tab order. You can move a tab afterward if needed.

Why does Shift+F11 change my Mac’s volume or desktop?
Your Mac or keyboard may be treating F11 as a system function. Try Fn+Shift+F11, change the function-key setting in macOS, or click the plus sign beside the worksheet tabs.

Can I use the shortcut if the workbook is protected?
Not if workbook-structure protection prevents adding sheets. You need the appropriate permission to remove that protection; a password may be required. Worksheet cell protection alone is a different setting.

Does adding a sheet copy the current worksheet?
No. Shift+F11 creates a blank worksheet. To preserve an existing sheet’s layout or formulas, use the sheet-tab menu’s Move or Copy command and choose to create a copy.

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.