How to Add Comments and Notes in Excel: A Complete Guide

Adding comments and notes in Microsoft Excel is a simple yet powerful way to communicate, explain data, and collaborate with others. Whether you’re working alone or with a team, these features help you add context without changing the actual data in your worksheet.

In this guide, you’ll learn the difference between comments and notes, how to use them, and best practices for effective collaboration.

What Are Comments and Notes?

In Excel, comments and notes serve different purposes:

• Comments (modern feature): Used for conversations and collaboration. These support replies and are ideal for teamwork.
• Notes (formerly called comments in older versions): Used for adding simple annotations or explanations to a cell.

Understanding this difference is important, especially when working with shared files.

How to Add a Comment in Excel

Comments are best when you want to start a discussion or give feedback.

Steps:

1. Select the cell where you want to add a comment
2. Go to the Review tab
3. Click New Comment
4. Type your message
5. Press Post

Once added:

• Others can reply to your comment
• You can tag people using @ (if using Microsoft 365)
• The comment appears as a thread

How to Add a Note in Excel

Notes are useful for simple explanations or reminders.

Steps:

1. Right-click the cell
2. Click New Note
3. Type your note
4. Click outside the cell to save

A small red triangle will appear in the corner of the cell to indicate a note.

Editing and Deleting Comments or Notes

To Edit:

• Click the cell
• Open the comment or note
• Make your changes

To Delete:

• Right-click the cell
• Select Delete Comment or Delete Note

Viewing Comments and Notes

You can easily view all comments and notes in your worksheet:

• Hover over a cell to see a note
• Click a cell to view its comment
• Use Review → Show Comments to open the comments pane

This is especially helpful when reviewing large datasets.

Differences Between Comments and Notes

Using Comments in Collaboration

When working with others using co-authoring in Microsoft Excel:

• Comments allow real-time discussions
• You can resolve comments once addressed
• Mentions notify specific users

This makes comments a key feature for teamwork and project tracking.

Best Practices for Using Comments and Notes

To keep your worksheet clean and easy to understand:

• Keep comments short and clear
• Use notes for explanations, not long discussions
• Resolve comments once issues are fixed
• Avoid adding too many notes in one sheet
• Use comments instead of editing someone else’s data without explanation

Common Issues and Solutions

1. Comments not showing
   Make sure the comments pane is open under the Review tab.
2. Notes not visible
   Hover your mouse over the cell or enable “Show All Notes.”
3. Cannot add comments
   You may have view-only access. Ask for editing permission.

Comments and Notes in Excel (Mac)

If you are using Excel on macOS, the steps are similar:

• Go to the Review tab
• Select New Comment or New Note
• Manage them the same way as in Windows

Conclusion

Comments and notes in Microsoft Excel help improve communication, reduce confusion, and make collaboration more effective. Use comments for discussions and teamwork, and notes for simple explanations or reminders.

By using both features properly, you can create clearer, more organized, and more professional Excel workbooks.

Read Also:

• How to Enable Co-Authoring in Excel: Work Together in Real Time
• Trendlines and Forecasting in Excel (Step-by-Step Guide for Beginners)