Adding and Managing Cell Comments in Excel

If you’ve ever opened an Excel spreadsheet built by someone else and had no idea what a particular cell’s value meant – you’re not alone. That’s exactly the problem cell comments solve. Comments let you attach explanations, reminders, or instructions directly to a cell without touching the data inside it. Whether you’re working solo or in a team, mastering Excel comments can save time, reduce errors, and make your spreadsheets far easier to understand.

What are cell comments in Excel? 🔗

Cell comments (and their close relative, Notes) are annotations you can attach to any cell in a spreadsheet. They sit invisibly in the background until a reader hovers over the cell, at which point they pop up as a small text box. According to Corporate Finance Institute, comments are commonly used to explain formulas, add reminders for other users, or cross-reference other workbooks – all without altering the actual cell data or formatting.

It’s worth knowing that Microsoft made an important distinction in newer versions of Excel. In Excel for Microsoft 365, what used to be called “comments” are now called Notes (shown with a red triangle), while the term Comments now refers to threaded, conversational annotations (shown with a purple icon) that support replies and @mentions. Older versions of Excel (2016, 2019) use the original single-box comment style. This guide covers both, so you’ll know exactly what to do regardless of your Excel version.

Inserting comments into cells 🔗

Adding a comment is straightforward, and there are a few ways to do it depending on your version of Excel and how fast you want to work.

Method 1: Right-click context menu 🔗

This is the quickest route for most users. Simply right-click the cell where you want to add the comment, then select New Comment (in Excel 365) or Insert Comment (in older versions). A text box will appear – type your annotation and click outside the box or press Escape to save it. As Spreadsheeto explains, in Excel 365 you can also use @mention someone’s name inside a comment to notify them directly via email, turning a simple note into a direct message.

Method 2: Using the Review tab 🔗

Go to the Review tab in the Excel ribbon and click New Comment. This opens the same text box. The Review tab is also your hub for navigating, showing, and managing all comments in a workbook, making it useful when you need more than just a quick insert. As CustomGuide describes it, think of cell comments as sticky notes that you can attach to any cell in your worksheet.

Method 3: Keyboard shortcut 🔗

For power users, the fastest way is the keyboard shortcut Shift + F2. This opens the comment/note box immediately on the selected cell – no mouse required. According to Microsoft Support, this shortcut works across most Excel versions, and pressing Ctrl + Enter posts the comment once you’re done typing.

Adding a Note vs. a Comment in Excel 365 🔗

If you’re on Excel 365 and want the classic yellow annotation box (without threaded replies), right-click the cell and choose New Note instead of New Comment. Notes display a red triangle in the upper-right corner of the cell, while threaded comments show a purple icon. Notes are better for simple, standalone annotations; comments are better when you need a back-and-forth conversation with collaborators.

Viewing and editing comments 🔗

Once comments are in place, knowing how to access and update them is just as important as knowing how to add them.

Viewing comments by hovering 🔗

The simplest way to read a comment is to hover your mouse cursor over the cell. The annotation pops up automatically without you needing to click anything. Cells with Notes show a small red triangle in the top-right corner as a visual indicator. You can also view all comments at once by going to Review > Show All Notes (or Show All Comments), which pins every annotation open on screen simultaneously – handy when reviewing a complex spreadsheet.

In Excel 365, the Comments pane (accessible from the Review tab) displays every comment in the workbook in a list view, and you can click any comment in the pane to jump directly to the relevant cell. This is particularly useful when working with large datasets spread across multiple sheets, as Microsoft’s official documentation confirms.

Editing an existing comment 🔗

To edit a comment or note, right-click the cell and select Edit Comment (or Edit Note in Excel 365). The text box reopens with your existing text, ready to be modified. Alternatively, use the Shift + F2 shortcut on a cell that already has a comment – it opens the comment for editing directly. Once you’ve made your changes, click anywhere outside the cell to save. For threaded comments in Excel 365, hover over the cell to reveal the comment thread, then click the pencil (edit) icon on your specific comment to revise it. Note that you can only edit comments you authored; other users’ replies are read-only for you.

Deleting comments 🔗

To delete a single comment, right-click the cell and choose Delete Comment or Delete Note. You can also select the cell and go to Review > Delete. If you need to clear comments from an entire worksheet at once, select all cells using Ctrl + A, then navigate to Home > Editing > Clear > Clear Comments. As Indeed notes, deleting comments after their purpose is served keeps spreadsheets clean and prevents outdated information from confusing future readers.

Utilizing comments for collaboration 🔗

Cell comments go far beyond personal note-taking. When multiple people work on the same Excel file, comments become a structured communication channel embedded directly into the data.

Threaded conversations and @mentions 🔗

Excel 365’s threaded comments allow team members to have full conversations inside a cell. One person raises a question, another replies, and the entire thread stays attached to the relevant data point. Using @mentions (typing @ followed by a colleague’s name) sends them an automatic email notification, so nothing gets missed even if they haven’t opened the file recently. As Layer explains, this feature transforms Excel from a passive data document into an active collaboration space. When a discussion is resolved, the thread can be marked as Resolved by any user with write access – it remains visible for reference but is closed to new replies unless explicitly reopened.

Annotating formulas and complex data 🔗

Comments are especially valuable for explaining non-obvious formulas or data sources. Instead of hoping a colleague understands why a cell uses a particular calculation, you can attach a note that says exactly what the formula does, where the data came from, or what assumptions are built in. This is standard practice in financial modeling and data analysis – Corporate Finance Institute highlights this use case specifically, noting that comments help users explain formulas and cross-reference other workbooks without cluttering the spreadsheet itself.

Tracking review feedback 🔗

During document reviews – whether it’s a budget, a project tracker, or a sales report – comments give reviewers a way to flag issues or suggest changes without editing the underlying data. This preserves the original content while making feedback visible and actionable. Once the feedback is addressed, the comment can be deleted or marked resolved, leaving a clean, finalized document. According to TrumpExcel, this workflow is especially practical when two versions of the same file exist, since Excel even lets you copy and paste comments between files using Paste Special > Comments.

Access and security considerations 🔗

One important thing to keep in mind: as Microsoft points out, comments are stored within the file itself, meaning anyone with edit access to the workbook can read and modify them. Before adding sensitive context – like a note explaining why certain figures were adjusted – consider whether all file recipients should have access to that information.

Practical tips to use comments more effectively 🔗

A few habits can make your use of Excel comments much more efficient. First, keep comments concise – a brief explanation is more useful than a paragraph. Second, use the Review > Next / Previous navigation buttons to move through comments in sequence rather than scrolling to find them manually. Third, if you’re preparing a spreadsheet for printing, be aware that comments don’t print by default; you’ll need to go to Page Layout > Page Setup > Sheet tab and change the “Comments” print setting if you want them included. Finally, for teams using shared workbooks regularly, establishing a simple convention – like who resolves threads and when – prevents comment clutter from accumulating over time.

What do you think? If your team currently uses email or chat to discuss spreadsheet data, how might shifting those conversations into Excel comments change the way you collaborate? And in your own work, are there specific types of cells – like formulas or summary totals – where adding a comment would make your spreadsheets clearer for others?

References

1. https://corporatefinanceinstitute.com/resources/excel/excel-comments/
2. https://spreadsheeto.com/excel-comments/
3. https://www.customguide.com/excel/insert-comment-in-excel
4. https://support.microsoft.com/en-us/office/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8
5. https://www.indeed.com/career-advice/career-development/how-to-delete-comment-in-excel
6. https://golayer.io/blog/excel/add-comments-and-notes-in-excel/
7. https://trumpexcel.com/insert-delete-comments-excel/