In Excel for Microsoft 365 on Windows, select a cell and press Shift+F2 to create a new note; if the cell already has a note, the same shortcut opens it for editing. Excel notes are the older, cell-attached annotations, distinct from threaded comments used for conversations and collaboration.
The Excel shortcut for a new note
The keyboard shortcut is Shift+F2. First select the cell that should carry the note, then press the keys together. Excel opens a note box connected to that cell. Type the note, then click outside the box to finish. The cell remains selected as the note’s anchor, so the text stays associated with that cell even if you later move or resize the note box.
If the selected cell already has a note, Shift+F2 opens that note for editing rather than adding a second one. This makes the shortcut useful both when recording a new explanation and when updating an existing annotation. A small indicator on a cell can show that a note is attached; its appearance depends on Excel’s display settings and version.
- Select the cell where the note belongs.
- Press Shift+F2.
- Enter the note text, or revise the existing text.
- Click elsewhere on the worksheet to close the editor.
What happens when you press Shift+F2
Excel opens a floating note box rather than placing the text in the cell itself. The cell’s value and formulas are not replaced by the note. For example, if cell C5 contains a delivery date, a note on C5 could explain that the date is provisional or identify the source of the estimate. The worksheet still displays the date in C5; the note is supplementary information.
A note is anchored to a cell, not to a particular screen position. If you sort or move worksheet data, take care to preserve the relationship between cells and their annotations. A note can also be repositioned or resized for readability, but doing so does not change the cell to which it is attached. To read a note without editing it, point to the cell or use the options on the Review tab, depending on the workbook’s settings and Excel version.
Shift+F2 is a toggle in practical use: it opens an existing note for editing, and the user closes the editing box by clicking away. It does not create a separate note for every press. If a selected cell has no note, the shortcut begins a new one; if it already has one, Excel opens that note.
Notes and threaded comments are different
Excel’s terminology can be confusing because Microsoft changed the name of older cell comments to notes when it introduced threaded comments. A note is a traditional annotation: it is attached to one cell and can hold explanatory text. It does not have a reply thread. A threaded comment is designed for discussion, with replies and features for collaboration in supported Microsoft 365 versions.
For a threaded comment in Excel for Microsoft 365 on Windows, select a cell and press Ctrl+Alt+M. That is not the shortcut for a new note. If you need to leave an instruction or explain an assumption without starting a conversation, use Shift+F2. If you want a colleague to respond, use a comment instead.
The distinction matters when following instructions written for older Excel releases. Older material may say to insert a comment with Shift+F2; in current Excel, that shortcut applies to notes. The feature may still be called a comment in older workbooks or help pages, but the current interface distinguishes Notes from Comments. Choose the item by its purpose, not just by the word used in an old tutorial.
Create a note from the ribbon or context menu
You can add a note without using a keyboard shortcut. Select the cell, open Review > Notes > New Note, and type in the note box. You can also right-click the selected cell and choose New Note when that command appears in the context menu. These routes are useful if the shortcut is unavailable, if you are using a touch-oriented workflow, or if you want to confirm that you are choosing a note rather than a threaded comment.
Ribbon labels and their placement can shift slightly as Microsoft updates Office. Look for the Notes controls on the Review tab; the same area also provides commands for showing, hiding, or managing notes. A command that says New Comment is for the threaded discussion feature, not the legacy note. If you only see comment-related choices, check the Notes menu or the selected cell’s right-click menu.
The menu route can also help when troubleshooting. If Review > Notes > New Note works but Shift+F2 does not, Excel supports the feature and the issue is more likely related to the keyboard, a function-key setting, or another application intercepting the shortcut.
Using the shortcut on Mac and Excel for the web
In Excel for Mac, Shift+F2 is also the shortcut associated with adding or editing a note. Some Mac keyboards use the function-key row for brightness, volume, or other system controls. In that case, you may need to hold Fn as well, or change the keyboard’s function-key settings so F2 is sent to Excel. The exact behavior depends on the Mac keyboard and macOS settings.
Excel for the web runs inside a browser, so keyboard shortcuts can be affected by browser behavior, the operating system, or the keyboard layout. If Shift+F2 does not open a note in the browser version, use the Review tab’s Notes controls or the cell’s context menu, if available in your current web interface. The desktop Windows instructions in this article are the primary reference; do not assume every shortcut behaves identically in every browser or platform.
When working across Windows and Mac, remember that the main note shortcut remains Shift+F2, but how the F2 key is sent can differ. The shortcut for a threaded comment is a separate command and may differ by platform, so use the Comment command shown in Excel’s interface rather than assuming the note shortcut will open a discussion.
Common problems and quick fixes
- The shortcut changes something else or does nothing: Confirm that Excel is active and a worksheet cell is selected. On a laptop or Mac, try the Fn key with Shift+F2 if the function row is assigned to hardware controls.
- A comment opens instead of a note: You may have selected the comment command or used its shortcut. Use Shift+F2 for a note, or choose Review > Notes > New Note.
- The note box appears but typing does not work: Click inside the note box before typing. If you opened an existing note, make sure the text area is in edit mode rather than merely displaying the note.
- You cannot see a note indicator: The note may be hidden, or indicators may be configured not to display as expected. Use the Notes controls on the Review tab to show or hide the note for the selected cell.
- You expected the note text to appear in the cell: Notes are separate annotations, not cell contents. They appear in a note box when shown; they do not alter the cell’s displayed value.
If a workbook is protected, shared, or opened with limited permissions, some editing commands may be unavailable. Check whether the worksheet allows editing and whether the file is in a mode that restricts changes. This is different from a shortcut problem: if the New Note command itself is disabled, changing the key combination will not grant permission to edit the sheet.
When a note is the right choice
Notes work well for concise explanations that should remain attached to a particular cell but do not need replies. Examples include documenting why a budget figure is an estimate, identifying an external source for a value, clarifying an unusual date, or leaving a reminder for the workbook’s next editor. They can keep worksheet cells uncluttered while still making supporting context available.
Use a threaded comment when the information is part of a conversation: for example, asking a colleague to verify a forecast or responding to a question about a figure. Use a separate documentation sheet or an external record when the explanation is long, needs formal review, or must be tracked beyond the workbook. Neither notes nor comments replace access controls or a reliable audit trail.
For a useful note, name the assumption or source clearly and keep the text specific to the cell. Instead of writing “check this,” describe what needs checking, such as “Confirm the Q3 exchange rate against the finance report.” Avoid placing sensitive information in a note unless the workbook is stored and shared appropriately; an annotation is still part of the workbook file and may be visible to people who can access it.
Frequently Asked Questions
What is the shortcut to insert a new note in Excel?
In Excel for Microsoft 365 on Windows, select the cell and press Shift+F2. Type the note, then click outside its box to finish. If the cell already has a note, the shortcut opens it for editing.
Is Shift+F2 for a note or a comment?
In current Excel, Shift+F2 is for adding or editing a note, the traditional cell annotation. For a threaded comment in Excel for Microsoft 365 on Windows, use Ctrl+Alt+M.
How do I add a note without using a shortcut?
Select the cell and choose Review > Notes > New Note. Depending on the interface, you can also right-click the cell and select New Note.
Why does Shift+F2 not work on my laptop?
The F2 key may be assigned to a hardware function such as volume or brightness. Try Fn+Shift+F2, check your keyboard’s function-key setting, or create the note through Review > Notes > New Note.
Can I use Shift+F2 to edit an existing note?
Yes. Select the cell that contains the note and press Shift+F2. Excel opens the existing note so you can revise it rather than creating another note.
Related
- How to Calculate Age in Excel from Date of Birth
- Excel Not Clicking the Correct Cell? Causes and Fixes
- Excel Copy and Paste Rows Into Columns: 3 Easy Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Tabbing to Next Cell? Fixes That WorkIn Excel for Microsoft 365 on Windows, pressing Tab while a worksheet cell is selected normally commits any…
- Excel Day of Year: Find the Day Number for Any DateTo find the day of the year in Excel, put a real Excel date in A2 and enter…
- Excel Bar Plot: How to Create and Format OneIn Excel for Microsoft 365 on Windows, select your category and value columns, then choose Insert > Insert…
- Average Excel File Size: What to Expect and Why It VariesThere is no single meaningful average Excel file size: a simple workbook may be only a few dozen…
- Find an Excel Password in a Protected File? Safe OptionsYou usually cannot find or reveal a password from inside a protected Excel file: Excel does not display…
- Excel: How Many Complete Months Are Between Two Dates?To find the number of complete months between two dates in Excel, use =DATEDIF(A2,B2,"m"), with the earlier date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.