You need to add extra information to a cell without changing its main content. This is for reminders, explanations, or feedback for other users. Excel provides two features for this: Comments and Notes, each with a distinct red corner indicator. This article explains the difference and shows you how to insert, view, and manage both types of cell annotations.
Key Takeaways: Adding Comments and Notes in Excel
- Review > New Comment: Creates a modern threaded comment for conversations, marked by a purple triangle and user initials.
- Review > New Note: Inserts a classic sticky note for static information, marked by a small red triangle in the cell corner.
- Right-click > Insert Comment/Note: The fastest way to add an annotation directly to a selected cell.
Understanding Excel Comments and Notes
Excel offers two annotation tools: Comments and Notes. They serve different purposes and have unique visual markers. Knowing which one to use is the first step.
What is a Modern Comment?
The modern Comment feature, introduced in recent versions, is designed for collaboration. When you add a comment, a purple triangle appears in the top-right corner of the cell. Clicking the cell reveals a conversation thread where you and others can reply. Each comment shows the user’s initials and a timestamp. This feature is ideal for discussing data and tracking feedback directly within the workbook.
What is a Classic Note?
A Note is the traditional Excel annotation, formerly called a “Comment” in older versions. It acts like a simple sticky note for one piece of information. A Note is indicated by a small red triangle in the cell’s top-right corner. Hovering your mouse over the cell displays the note’s text in a yellow box. Notes are perfect for personal reminders or static explanations that do not require a discussion thread.
Steps to Insert a Comment or Note
You can add annotations using the ribbon menu or a right-click context menu. The steps are similar for both features.
Method 1: Using the Ribbon
- Select the target cell
Click on the cell where you want to place the annotation. - Go to the Review tab
Navigate to the Review tab on the Excel ribbon. - Choose New Comment or New Note
To start a conversation, click the New Comment button. To add a static note, click the dropdown arrow next to New Comment and select New Note. - Enter your text
A text box will appear. Type your message and then click anywhere outside the box to save it.
Method 2: Using Right-Click
- Right-click the cell
Select the cell and right-click to open the context menu. - Select the insert command
From the menu, choose Insert Comment or Insert Note. The command name depends on your Excel version and default settings. - Type and save
Enter your text in the box that appears. Click outside the box to save the annotation to the cell.
Common Mistakes and Limitations
Users often confuse the two features or run into visibility issues. Here are typical problems and how to avoid them.
Cannot See the Red Triangle Indicator
If the small red or purple corner marker is not visible, check your Excel settings. Go to File > Options > Advanced. Under the Display section, ensure the indicators are enabled. Look for the setting “For cells with comments, show:” and select “Indicators only, and comments on hover” or a similar option. If this is off, annotations will not show any visual cue.
Accidentally Creating the Wrong Annotation Type
The right-click menu command can default to one type. If you insert the wrong kind, you can convert it. Right-click the cell with the annotation, choose the relevant option from the menu (like Convert to Note or Convert to Comment), and select the desired type. This changes the annotation’s functionality and marker.
Notes Not Printing
By default, cell notes do not print with the worksheet. To print them, you must adjust the page setup. Go to Page Layout > Page Setup dialog launcher. On the Sheet tab, under the Print section, find the “Comments” dropdown. Select “At end of sheet” or “As displayed on sheet” to include notes in your printout.
Comment vs Note: Key Differences
| Item | Modern Comment | Classic Note |
|---|---|---|
| Primary Use | Collaborative discussion threads | Static information or personal reminder |
| Cell Indicator | Purple triangle | Small red triangle |
| Viewing Method | Click cell to open thread pane | Hover mouse over cell |
| User Identification | Shows initials and timestamp | No user info shown |
| Editing | Allows replies and resolves | Simple text edit only |
You can now add context to your data using the correct annotation. Use Notes for simple reminders and Comments for team discussions. Try using the Review > Show All Comments command to toggle the visibility of every comment thread in your sheet. For advanced control, use the keyboard shortcut Shift + F2 to insert a note in the selected cell quickly.