You are learning The Excel Interface
How do I use comments to add notes to specific cells?
Adding comments in Excel is a handy way to provide explanations, instructions, or reminders directly linked to specific cells. Here's how to do it:
Adding a Comment:
1. Select the cell: Click on the cell where you want to add a comment.
2. Right-click: Right-click on the selected cell.
3. Choose "Insert Comment" or "New Note" (depending on Excel version):
- In most Excel versions, you'll see an option called "Insert Comment" after right-clicking.
- If you're using Excel for Office 365, you might see "New Note" instead. Both options achieve the same outcome.
4. Type your comment: A small comment box will appear next to the cell. Enter your explanatory text or note within this box.
5. Click outside the cell (or press Enter): Clicking on any other cell or pressing Enter will finalize the comment and collapse the comment box.
Viewing and Editing Comments:
- Hover over the cell: When you hover your mouse over a cell with a comment, a small red triangle will appear in the top right corner. This indicates the presence of a comment.
- Click on the red triangle or the comment box: Clicking on either the red triangle or the comment box itself will expand the comment and display the text you entered.
- Edit the comment: Once expanded, you can edit the existing comment by making changes directly within the comment box.
- Click outside the comment box to save changes.
Additional Options:
- Formatting comments: You can format the text within the comment box using basic formatting options like bold, italics, or font size. Right-click on the border of the comment box (not inside the text area) and choose "Format Comment" to access formatting options.
- Deleting comments: Right-click on the cell with the comment and choose "Delete Comment" to remove the comment entirely.
Tips:
- Comments are a great way to collaborate on spreadsheets. You can see who added the comment by looking at the username displayed at the top of the comment box.
- Use comments to document formulas, explain complex calculations, or provide additional context for specific data points.