Learn › Excel › Add a new sheet

Excel new sheet shortcut: Shift + F11

Add a new, empty worksheet next to your first sheet in one press.

← All Excel shortcuts

With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.

WindowsShift+F11
MacShift+F11

Keys on keyboards of other languages

The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.

Laptops with an Fn key: the F keys (F2, F4, F5, F11...) usually need Fn pressed together with them, for example Fn + F4. If Fn Lock is on, they work without Fn.

English (US)Shift+F11 · on laptops with Fn: Shift+Fn+F11
HrvatskiShift+F11 · on laptops with Fn: Shift+Fn+F11
DeutschUmschalt+F11 · on laptops with Fn: Umschalt+Fn+F11
EspañolShift+F11 · on laptops with Fn: Shift+Fn+F11
FrançaisShift+F11 · on laptops with Fn: Shift+Fn+F11
PortuguêsShift+F11 · on laptops with Fn: Shift+Fn+F11
ItalianoShift+F11 · on laptops with Fn: Shift+Fn+F11
TürkçeShift+F11 · on laptops with Fn: Shift+Fn+F11
Bahasa IndonesiaShift+F11 · on laptops with Fn: Shift+Fn+F11
PolskiShift+F11 · on laptops with Fn: Shift+Fn+F11

What it does

Shift + F11 adds a new, empty worksheet next to the ones you have. It gets a name like Sheet1, and you can rename it by double-clicking its tab.

When to use it

Use it to keep data, a summary or a chart apart from the main table, without opening a menu or clicking the plus button.

How to do it

  1. Press Shift + F11. On many laptops hold Fn too: Shift + Fn + F11.
  2. A blank sheet appears next to your first sheet.
  3. Double-click its tab to give it a name you will recognize.
Good to know: You can also click the plus button next to the sheet tabs, which does the same without the keyboard.

A quick example

In the Tasks workbook, press Shift + F11: a blank sheet opens next to the Tasks sheet.

Shift + F11 and the plus button

Shift + F11 and the plus button next to the sheet tabs both add a worksheet. The shortcut is faster because your hands stay on the keyboard.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box.
  • Your laptop needs Fn: on many laptops the F keys work only together with Fn, so press Shift + Fn + F11.
  • The new sheet is not where you expected: Excel adds it next to the active sheet. Drag its tab to move it.
  • Nothing is added: the workbook may be protected. Unprotect the structure of the workbook first.

Quick answers

What is the shortcut to add a new sheet in Excel?

Press Shift + F11. On many laptops press Shift + Fn + F11.

How do I rename the new sheet?

Double-click its tab at the bottom, type the new name and press Enter.

Is there another way to add a sheet?

Yes. Click the plus button next to the sheet tabs.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games