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.
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.
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.
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
- Click the cell you want to add a note to.
- Press Shift + F2 (on many laptops: Shift + Fn + F2), type your note and click away. A small red mark appears on the cell.
- Press Shift + F11 (on many laptops: Shift + Fn + F11) to add a new sheet. It appears next to your first sheet.
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.
Shortcuts mentioned on this page, with video:
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.

