Buzz
Throughout your use of Excel spreadsheets, certain data cells stand out that you must remember to avoid confusion or overlooking vital information. Excel facilitates the addition of annotations to data cells, enabling you to provide detailed explanations to aid in memory recall.
This article instructs you on how to add annotations to Excel spreadsheets.
1. Add annotations to cells within Excel spreadsheets.
Step 1: Choose the cell you want to annotate and go to the Review tab -> New Comment.
Step 2: A note window will appear next to the selected cell, where you can input your annotation content.
Afterwards, click on any cell to hide the note. The annotated cell will display a red mark above it. To view the note, simply hover over or click on the cell.
To edit or delete annotations, select the cell in Excel, then go to the Review tab and choose Edit Comment (to edit) or Delete (to delete).
2. Adding annotations to Excel formulas.
Use the additional syntax +N('enter annotation content') after the formula in Excel.
The formula's result still calculates normally, but selecting the cell will display the added annotation in the Function Bar.
Now you can avoid confusion in large Excel data files by adding important and necessary notes. Wish you success from now on!
