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.