Add, Show, or Hide Comments in Spreadsheet Cells
Yes. In spreadsheet apps, you can add a comment or note to a cell, then show or hide it without changing the cell’s value. The exact controls differ between Excel and Google Sheets, and comments designed for discussion may behave differently from simple notes.
Comments and Notes Are Not the Same
A cell comment is attached to a particular cell and can explain its contents, ask a question, or record a decision. For example, a comment on a projected expense might ask a colleague to confirm the estimate. The comment is separate from the cell’s displayed value and formula.
Some spreadsheet apps distinguish between threaded comments and notes. Threaded comments support replies and collaboration, while notes are generally simple annotations without a conversation thread. Excel uses both terms for different features in current versions. Google Sheets calls its collaborative discussion feature a comment and also offers a note. Names and available options can vary by app and version, so check which feature you need before adding one.
Add a Comment in Excel
In current desktop versions of Excel, select the cell and use the Review tab to create a new comment. The command is commonly labeled New Comment; choose New Note instead if you want a basic annotation. You can also right-click the cell and look for the relevant comment or note command. After entering the text, post or save it as prompted.
- Select the cell you want to annotate.
- Open Review and choose New Comment or New Note.
- Type the explanation or question, then post the comment or click outside the note to finish editing.
To reply to a threaded comment, open it and use the reply field. If you only need to provide context such as “Values copied from the April report,” a note may be more appropriate than a discussion thread.
Show or Hide Comments in Excel
A comment can be present without its text box being open. Select the cell to view its comment, or open the comment from the Review tab. Depending on the Excel version and comment type, commands may include Show/Hide Comment or Show/Hide Comments. A note can have its own show-or-hide command. The wording and behavior differ across versions, especially between threaded comments and older-style notes.
To hide an open comment or note, use the corresponding hide command or click away from the cell. Hiding it does not delete it. Other users with access to the workbook may still be able to open it, and a comment may remain visible to its author or participants in a collaboration interface.
If the goal is to inspect many annotations at once, look on the Review tab for controls to show comments or notes. These controls affect visibility, not the spreadsheet’s data. Avoid using a delete command when you only want to clear the screen.
Add and Manage Comments in Google Sheets
In Google Sheets, select a cell and use Insert > Comment to add a discussion comment. Type your message and post it. To attach a plain annotation instead, choose Insert > Note. A right-click menu may also provide these actions, depending on the interface.
Comments can be opened from the cell’s indicator or through the comment controls. A posted thread can be replied to, resolved, or otherwise managed by users who have the necessary access. Resolving a thread marks its discussion as finished; it is not the same as deleting the cell or its contents. Notes, by contrast, are typically shown when the pointer is over the cell rather than managed as a reply thread.
When sharing a file, remember that comment access depends on the file’s sharing permissions. Someone who cannot access the spreadsheet may not be able to see its comments, while someone with sufficient access may see more than the cell’s owner expects. Review sharing settings if comments are intended for a particular group.
Choose the Right Visibility Setting
Showing comments is useful during review, when you need to answer questions or verify assumptions. Hiding them can make a dense sheet easier to read or prepare a cleaner view for a meeting. In either case, the annotation remains associated with its cell unless you explicitly delete it.
- Show one comment: Use the selected cell’s comment control or the app’s Review options when checking a specific question.
- Show several or all: Use the app’s broader review controls when auditing a workbook. Be aware that many open comment boxes can cover data.
- Hide comments temporarily: Use a hide command or close the comment display. This preserves the discussion.
- Remove an annotation: Choose delete only when the comment or note is no longer needed. Deleting may remove its conversation, not merely hide it.
Comments are not a reliable way to conceal sensitive information. They can be revealed by users with suitable workbook access, and they may be included when a file is shared or copied. Do not put passwords, private personal details, or other information in a comment merely because it is currently hidden.
Common Problems and Practical Checks
If you cannot find a comment, first confirm that you selected the correct cell. Then distinguish a comment from a note: the two can have different icons, menus, and display behavior. In a shared workbook, check whether the comment is resolved, whether you have permission to view it, and whether the app is displaying the relevant comment panel or indicator.
If a comment box is covering cells, hide it rather than deleting it. If a comment seems to have disappeared after editing, check the app’s comment history or review interface; the exact recovery options depend on the app and the actions taken. For workbooks opened in a different spreadsheet program, some comment formatting or collaboration features may not appear exactly as they did in the original app.
A useful habit is to make the cell itself understandable where possible. A comment can explain an assumption, but it should not be the only place that essential instructions or data definitions exist, especially if the sheet will be exported or viewed in another application.
Frequently Asked Questions
How do I show a hidden comment in a cell?
Select the cell and use the app’s Review or comment controls to open the comment. In Excel, look for the show-comment command; in Google Sheets, select the cell’s comment indicator or open the comment interface.
Does hiding a comment delete it?
No. Hiding changes whether the comment is displayed, not whether it is stored. Use a delete command only if you intend to remove the annotation or discussion.
What is the difference between a comment and a note?
A comment is generally suited to a discussion with replies. A note is usually a simple piece of explanatory text attached to a cell. Exact features and labels depend on the spreadsheet app.
Can I show all comments at once?
Many spreadsheet versions provide review controls to display multiple comments or notes, but availability and behavior vary. Check the Review tab or the app’s comment panel, and hide the boxes afterward if they obscure the sheet.
Can other people see a hidden cell comment?
They may be able to, if they have access to the spreadsheet. Hiding is a display choice, not a privacy or permission setting; use sharing controls to manage access.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.