How to Insert Comment in Excel - Practical Guide

Learn how to insert comments in Excel to add notes, explanations, and feedback to cells without modifying data. Comments enhance collaboration by allowing team members to communicate insights, ask questions, and document decisions directly within the spreadsheet, improving clarity and workflow.

Why This Matters

Comments enable team collaboration and documentation within spreadsheets, making it easier to track changes, clarify data sources, and provide context without altering cell contents.

Prerequisites

•Basic Excel navigation and cell selection skills
•Understanding of spreadsheet structure

Step-by-Step Instructions

Select the target cell

Click on the cell where you want to add a comment to select it.

Access the Insert Comment option

Go to Review > New Comment (Excel 365/2019/2016) or right-click the cell and select Insert Comment.

Type your comment text

Enter your note or feedback in the comment box that appears next to the selected cell.

Format the comment (optional)

Use bold, italic, or underline formatting from the floating toolbar to emphasize text within the comment.

Finalize the comment

Click outside the comment box or press Escape to save and close the comment; a small indicator appears on the cell corner.

Alternative Methods

Right-click context menu

Right-click any cell and select Insert Comment from the dropdown menu for quick access without navigating the ribbon.

Keyboard shortcut method

Use Shift+F2 to instantly open the comment box for the selected cell, providing the fastest insertion method.

Tips & Tricks

✓Use comments for metadata like data sources, calculation explanations, or assumptions to maintain spreadsheet documentation.
✓Format comments with bullet points or numbered lists for better readability and organization.
✓Hover over cells with comment indicators to preview comments without opening them.
✓Delete outdated comments by right-clicking and selecting Delete Comment to keep your sheet clean.

Pro Tips

★Use @ mentions (Excel 365 only) by typing @username in comments to tag specific team members for direct notifications.
★Edit comments by double-clicking the cell or clicking the Edit option in the comment box to revise feedback.
★Copy comments between cells by selecting a cell with a comment, copying it, then using Paste Special > Comments in the destination.
★Show all comments at once via Review > Show All Comments to audit feedback across the entire sheet.

Troubleshooting

Comment box won't open when clicking Review > New Comment

Ensure the cell is properly selected (highlighted in blue). If still failing, try the keyboard shortcut Shift+F2 instead, or restart Excel if the feature remains unresponsive.

Comment indicator appears but comment text is invisible

The comment may be formatted with white text or hidden outside the visible area. Double-click the cell to edit and verify the comment content is visible.

Comments disappear after saving the file

Ensure you're saving in Excel format (.xlsx or .xls), not CSV or other formats that don't support comments; check file extension before saving.

Cannot edit or delete another user's comment

In shared workbooks, comments have author-level permissions; only the original author or admin can modify. Contact the comment creator or spreadsheet owner for edits.

Frequently Asked Questions

Can I see all comments in a spreadsheet at once?

Yes, navigate to Review > Show All Comments to display all comments simultaneously across your sheet. This is useful for reviewing feedback during collaboration or quality audits.

How do I reply to a comment in Excel?

In Excel 365, click a comment and select the reply option to add responses within the same comment thread. In older versions, you must use separate comments for each message.

Can comments be printed or exported?

Yes, go to File > Print and select Print Comments under Print Layout options, or copy comments to a separate sheet for external documentation. Comments are also included in PDF exports if the option is enabled.

What's the maximum length of a comment?

Excel comments can contain thousands of characters with full formatting support, so length is rarely a practical limitation for most documentation needs.

Do comments affect file size significantly?

Comments add minimal file size impact unless they contain embedded images; text-based comments consume negligible space even in large quantities.