Learn › Excel › Add a note or a new sheet

Excel note and new sheet shortcuts: Shift + F2, Shift + F11

Shift + F2 adds a note to the selected cell, and Shift + F11 adds a new sheet.

← 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+F2
MacShift+F2

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+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
HrvatskiShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
DeutschUmschalt+F2 · Umschalt+F11 · on laptops with Fn: Umschalt+Fn+F2 · Umschalt+Fn+F11
EspañolShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
FrançaisShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
PortuguêsShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
ItalianoShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
TürkçeShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
Bahasa IndonesiaShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11
PolskiShift+F2 · Shift+F11 · on laptops with Fn: Shift+Fn+F2 · Shift+Fn+F11

What it does

Shift + F2 opens a note on the selected cell, where you can write a reminder or an explanation. A small red mark in the corner of the cell shows that it has a note. Shift + F11 adds a new, empty worksheet next to the ones you have.

When to use it

Use a note to explain a number, leave a hint for a colleague or remember why a value changed. Use a new sheet to keep data, a summary or a chart apart from the main table without opening a menu.

How to do it

  1. Click the cell you want to add a note to.
  2. Press Shift + F2 (on many laptops: Shift + Fn + F2), type your note and click away. A small red mark appears on the cell.
  3. Press Shift + F11 (on many laptops: Shift + Fn + F11) to add a new sheet. It appears next to your first sheet.
Good to know: Hover over a cell with a red mark to read its note. A new sheet gets a name like Sheet1, so rename it to something you will recognize by double-clicking its tab.

A quick example

In the task list, click A3 and press Shift + F2, type Ask Leo first and click away: a red mark appears on the cell. Then press Shift + F11: a blank sheet opens next to the Tasks sheet.

Notes, comments and new sheets

A note is a simple yellow text box attached to a cell, while comments are conversations that several people can reply to. For a new sheet you can also click the plus button next to the sheet tabs, and Shift + F11 does the same without the mouse.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box.
  • The note starts with your name: Excel adds the author name at the top. Select it and delete it, or write your note under it.
  • You cannot see the note: hover over the cell with the red mark.
  • The new sheet is not where you expected: Excel adds it next to the active sheet. Drag its tab to move it.
  • On a laptop where the F keys control volume and brightness, hold Fn together with the shortcut.

Quick answers

What is the shortcut to add a note in Excel?

Click the cell and press Shift + F2 (on many laptops: Shift + Fn + F2). Type your note and click away, and a small red mark shows that the cell has a note.

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

Press Shift + F11 (on many laptops: Shift + Fn + F11). A new blank sheet appears next to your sheets.

How do I read a note?

Hover over the cell with the small red mark and the note appears.

How do I rename a new sheet?

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

← All Excel shortcuts

Chrome extensions

Free web tools

Free games