top of page

You are learning The Excel Interface

How do I add comments to cells for notes or explanations?

Adding comments in Excel is a great way to include notes or explanations directly within your spreadsheet.
Here's how you can do it:

Two Methods to Add Comments:

1. Using the Ribbon:

- Select the cell you want to add a comment to.
- Go to the Review tab on the ribbon.
- In the Comments section, click the New Comment button (it looks like a small speech bubble).

2. Using Keyboard Shortcut or Right-Click Menu:

- Select the cell you want to comment on.
- Keyboard Shortcut: Press Shift + F2.
- Right-Click Menu: Right-click on the selected cell.
- From the context menu, choose Insert Comment (or New Note in Excel for Office 365).

Adding Your Comment:

A small yellow box will appear next to the cell. This is where you can type your comment.

Viewing and Hiding Comments:

By default, comments only appear as a small red triangle in the top right corner of the cell.

To view the comment, hover your mouse over the red triangle. The full comment will appear in a tooltip.

Hiding Comments: If you don't want to see the red triangles cluttering your spreadsheet, you can go back to the Review tab and click the Show/Hide Comments button (it looks like a red triangle with an exclamation mark).

Additional Tips:

- You can format the text within the comment box using basic formatting options like bold, italics, or font size.

- To edit a comment, simply click on the yellow box again and make your changes.

- To delete a comment, right-click on the yellow box and choose Delete Comment.

- By default, comments are hidden unless you hover your mouse over the cell or click on the yellow box.

- You can show or hide all comments in your worksheet by going to the Review tab and clicking the Show/Hide Comments button.

By using comments, you can keep track of important information, questions, or explanations directly tied to specific cells in your spreadsheet, improving clarity and collaboration.

bottom of page