Add, create comments in Excel

In the process of using Excel worksheet, there are many special data cells you need to remember to avoid confusion or forgetting some information. In Excel worksheet, support you to add comments for data cells, you can add comments to explain more about the data cell so that when you forget you can select the data cell to view again.

Add, create comments in Excel Picture 1

The following article shows you how to add annotations to Excel spreadsheets.

1. Add comments to cells in Excel spreadsheets.

Step 1: You select the cell to note and select Review tab -> New Comment .

Add, create comments in Excel Picture 2

Step 2: A note window appears right next to the cell you choose, you enter the text of the note.

Add, create comments in Excel Picture 3

Then you click on any box, the note will be hidden and the note box will display the red mark on the top of the cell, you want to see the note just drag or click on that cell.

Add, create comments in Excel Picture 4

To edit or delete comments, select the cell in Excel and in the Review tab, select Edit Comment (edit), Delete (delete).

Add, create comments in Excel Picture 5

2. Add comments to Excel formulas.

Use the syntax + N ("enter comment text") after the formula in Excel.

Add, create comments in Excel Picture 6

The results of the formula are still normal, but when you select that cell on the Funtion bar will display the comment you add.

Add, create comments in Excel Picture 7

Now that you don't need to worry about confusion in large Excel data files, you can add notes to important and necessary information. Good luck!