1
Shift + F2Insert or edit a note (legacy comment)
Adds a balloon-style note to the selected cell. If a note already exists, it enters edit mode.
Tip: Press Esc to finish editing and return to the cell.
CommentsNotesShift+F2
Add Comments and Notes to Excel Cells Quickly
with Shift+F2
When you want to leave supplementary information or warnings on a cell, writing directly in the cell breaks the print layout. Comments and notes let you attach information invisibly, displaying only when needed.
Shortcuts you will master in this article
Shift + F2
Without a designated place for supplementary information, management overhead grows
In inherited files with unexplained values, writing in the cell breaks the layout; writing in a separate document creates reference drift. The comment and note features let you attach information directly to a cell where it stays contextually linked.
In Excel 365 and later, there are two types: comments (threaded posts with reply support) and notes (the original balloon-style type). Notes are best for simple annotations; comments are better for back-and-forth review discussions.
How to Add, Edit, and Delete Comments and Notes
Everything from adding to managing comments, achievable entirely with the keyboard.
2
Keep a note permanently visibleToggle between always-visible and hover-only display
Right-click the note → 'Show/Hide Note' to toggle between always-visible and hidden modes.
Tip: Keeping it visible while reviewing makes it easier to read.
3
Delete keyDelete key removes cell content, not notes
Pressing Delete on a cell with a note removes the cell content only — the note is not deleted.
Tip: To delete a note, right-click → 'Delete Note'.
4
Shift + F2 (in edit mode)Edit an existing note
Pressing Shift+F2 on a cell that already has a note opens it for editing. Update the content and press Esc to finish.
Tip: To apply the same note to multiple cells, use paste (format only).
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
How to Use Comments and Notes Effectively in Practice
Attaching the basis for a number or calculation logic directly to its cell reduces explanation overhead when handing off work.
Supplementary information that shouldn't appear in print belongs in notes.
Use threaded comments for review discussions; use notes for simple annotations.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Shift + F2 | Insert/Edit Comment |
Delete | Clear Cell Contents |
F2 | Edit Cell |
Frequently Asked Questions
Q. Why does Shift+F2 insert a note instead of a comment?
A. In Excel 365 and later, the old 'comments' were renamed 'notes'. Threaded comments with reply functionality are now inserted via Insert → Comment.
Q. Can I include notes in printed output?
A. Yes. In Page Setup → Sheet tab, the 'Comments and notes' option lets you control how they appear when printed.
Q. Too many notes are making the cells hard to read.
A. Go to Review → Show All Notes and toggle it off to hide the balloons. Notes will then appear only on hover.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →