You can insert a note to provide feedback on the contents of a cell.
How to insert a note
To insert a note, do the following:
- Select a cell.
- Right click on it and then select command Insert Comment (Insert note).
- Enter your comment.
Excel will display a red triangle in the upper right corner of the cell.
- Click outside the note field.
- Hover over a cell to see the comment.
Excel automatically adds the username to the note. To change this name, follow these steps.
- Click on the tab Fillet (File), click on Options (Settings) and select the tab General (General).
- Change your username.
How to edit a note
To edit a note, follow these steps:
- Select the cell containing the comment you want to edit.
- Right click on it and then click Edit Comment (Change note).
- Edit your comment.
To delete a note, click Delete Comment (Remove note).
How to show or hide a note
By default, a comment is only visible when you hover over a cell that contains a comment. To keep notes visible at all times, follow these steps:
- Select, for example, a cell B4.
- On the Advanced tab Review (Review) in a group Comments (Notes) click Show/Hide Comment (Show or hide note).
- Select another cell.
To hide a note, select a cell B4 and click on command again Show/Hide Comment (Show or hide note). To show all notes on a sheet at once, click Show All Comments (Show all notes).