Excel Comments vs Notes: What Is the Difference and When to Use Each

Excel offers two features for adding annotations to cells: Comments and Notes. Many users are unsure which tool to use for different tasks, leading to confusion in shared workbooks. Comments are designed for threaded conversations, while Notes are for simple, static annotations. This article explains the technical differences between Comments and Notes and provides clear guidance on when to use each one.

The Evolution of Annotations in Excel

Excel’s annotation system has changed significantly over recent versions. The feature once called “Comments” was renamed to “Notes” in Office 365. A new, collaborative feature called “Comments” was introduced to replace it. This change can cause confusion, as the names were swapped but the functions remained distinct. The modern Comment is a threaded discussion tool integrated with Microsoft 365. The Note is the classic yellow box for a single piece of text. Understanding this history is key to using the right tool. Your Excel version determines which features are available by default.

Technical Specifications of Comments

Modern Comments are built for collaboration. They are stored separately from cell data and are part of the workbook’s revision metadata. Each comment can have multiple replies, creating a conversation thread. They support @mentions, which send email notifications to collaborators. Comments have a resolved/unresolved status, allowing teams to track feedback. They appear in the Comments pane on the right side of the window, not just in a pop-up box. This design makes them unsuitable for permanent, reference-style annotations that should always be visible.

Technical Specifications of Notes

Notes are simple text boxes anchored to a specific cell. They are stored as part of the cell’s formatting properties. A Note contains only one block of text from a single author, with no threading or reply capability. They do not trigger notifications or have a resolution status. The classic Note indicator is a small red triangle in the corner of a cell. Hovering over the cell displays the Note’s content in a pop-up. Notes are best for information that does not require a discussion, such as a data source explanation or a calculation reminder.

How to Insert and Manage Comments and Notes

The methods for adding Comments and Notes are similar but accessed through different menus. The ribbon interface groups these features under the Review tab. You can also use right-click context menus for quick access. Managing visibility is done through the Show Comments and Show Notes buttons.

1. Insert a Modern Comment
   Select a cell. Go to Review > New Comment, or press Shift+F2. Type your comment. Use @ followed by a collaborator’s name to mention them. Click the Post button to publish it to the thread.
2. Insert a Note
   Select a cell. Go to Review > Notes > New Note. Alternatively, right-click the cell and select New Note from the menu. Type your annotation text. Click outside the note box to save it.
3. View and Navigate Annotations
   Go to Review > Show Comments to open the Comments pane and see all threads. Go to Review > Notes > Show All Notes to display every note indicator in the sheet. Use Review > Next and Previous to jump between annotations.
4. Edit or Delete
   For a Comment, click its cell and then the comment icon to open the thread. Click the edit (pencil) icon on a specific reply to change it. For a Note, right-click the cell and select Edit Note or Delete Note.

Common Mistakes and Limitations to Avoid

Choosing the wrong annotation type can create clutter or break collaborative workflows. Notes are often misused for feedback that requires a response, leaving questions unanswered. Comments are overused for static reference info, creating unnecessary notification noise.

“My Comments Disappeared When I Saved the File”

This usually happens when comments are marked as resolved. In the Comments pane, click the “Show Comments” dropdown and select “Show resolved comments” to view them. Resolved comments are hidden by default to clean up the view. They are not deleted. For permanent, always-visible text, you should use a Note instead.

“I Can’t See the Red Triangle Note Indicators”

Note indicators can be turned off. Go to File > Options > Advanced. Under the Display section, check the setting for “Indicators only, and comments and notes on hover” or “No comments or notes”. Ensure the first option is selected to see the red triangles. Also, verify that Show All Notes is enabled in the Review tab.

“@Mentions in Comments Are Not Sending Email”

Email notifications for @mentions require the workbook to be saved to OneDrive, SharePoint, or a network location mapped to a Microsoft 365 service. Local files saved on your C: drive will not trigger emails. All mentioned users must also have edit permissions to the shared file location for notifications to work correctly.

Excel Comments vs Notes: Feature Comparison

Item	Comments (Modern)	Notes (Legacy)
Primary Purpose	Threaded discussion and feedback	Static annotation or reminder
Collaboration Features	@mentions, replies, resolve status, email alerts	None; single text block
Visibility & Pane	Appears in dedicated Comments task pane	Pop-up on hover; no dedicated pane
Best Use Case	Reviewing a draft, asking questions, team feedback	Explaining a formula, citing a source, personal memo
Keyboard Shortcut	Shift+F2	Shift+F2 (context-dependent)

You should now understand the distinct roles of Comments and Notes in Excel. Use Comments in the Review pane for collaborative discussions that need follow-up. Use Notes for simple explanations that remain attached to a cell. Try using the Review > Next button to quickly cycle through all annotations in a sheet. For advanced use, you can convert all legacy Notes to modern Comments via Review > Notes > Convert to Comments, but this action is one-way and cannot be undone.