Adding a note to a cell takes three clicks
Open your spreadsheet in Excel. Right-click the cell where you want to add a note. Select Insert Note from the menu that appears. Type what you want to remember about that cell, then click outside the note box to save it.
A small red triangle appears in the corner of the cell to show a note is there. When you hover your mouse over that cell later, the note pops up so you can read it without opening anything. If you want to edit the note, right-click the cell again and choose Edit Note.
Notes stay attached to the cell even if you move the data around, copy the cell to another sheet, or share the file with someone else. They are useful for explaining why a number is what it is, flagging cells that need checking, or reminding yourself what a column means.
Key Takeaways
- Right-click a cell and select Insert Note to add a comment that stays with that cell permanently.
- A small red triangle marks cells with notes, and the note appears when you hover over the cell.
- Notes travel with the cell if you copy it, move it, or send the file to someone else.
- Use notes to explain numbers, flag cells for review, or document why data looks the way it does.
- Edit or delete a note by right-clicking the cell and choosing Edit Note or Delete Note.
When to use notes instead of putting text in a cell
A note is invisible until someone hovers over the cell, so it does not clutter your spreadsheet the way text in a neighboring cell would. Use a note when you want to explain something without taking up space or changing the layout of your data.
If you are tracking a budget and one line item is unusually high, add a note to that cell explaining why instead of typing an explanation in column E. If you are sharing a spreadsheet with a team and one person's numbers look wrong, add a note flagging it for them to check. If you built a formula that does something non-obvious, document it in a note so the next person who opens the file understands what you did.
Notes also work better than text when you want to keep the spreadsheet clean for printing or exporting. The note does not print unless you specifically tell Excel to include notes in the print settings, so your data stays readable on paper.
Deleting or editing a note you already added
To change what a note says, right-click the cell with the red triangle and select Edit Note. The note box opens and you can type over the old text or add to it. Click outside the box when you are done.
To remove a note entirely, right-click the cell and choose Delete Note. The red triangle disappears and the note is gone. If you delete a note by mistake, use Ctrl+Z (or Cmd+Z on Mac) to undo the deletion when ready.
Printing notes with your spreadsheet
By default, notes do not print when you print your spreadsheet. If you want to include them, go to File > Print and look for a section called Print Options or Settings. You should see a choice that says something like Print Notes or Comments. Select that option and the notes will appear on the printed page next to the cells they belong to.
Notes print in a different location than they appear on screen — usually in a box below or beside the cell — so check the preview before you print to see how it will look. If the notes make the printout too crowded, you can always print without them and keep the notes digital only.
Sharing spreadsheets with notes attached
When you send an Excel file to someone else, the notes come with it. They will see the same red triangles and be able to hover over cells to read your notes. This makes notes a good way to communicate with teammates without changing the actual data.
If you are using Excel Online (the web version), notes work the same way — right-click a cell and insert a note. The notes sync across devices, so if you add a note on your computer, it shows up when you open the file on your phone or tablet.
Differences between notes and comments in older Excel versions
Older versions of Excel called notes "comments," and the process was slightly different. If you are using Excel 2016 or earlier, right-click a cell and look for Insert Comment instead of Insert Note. The functionality is the same — you type text that stays with the cell — but the menu labels are different.
If you open a file created in an older version of Excel in a newer version, the comments automatically become notes and work the same way. You do not need to convert them or do anything special.
Frequently Asked Questions
Can I format text inside a note, like making it bold or changing the color?
No. Notes are plain text only — you cannot make words bold, italic, or colored. If you need formatted text, you would have to put it in a separate cell instead of using a note. Some spreadsheet programs like Google Sheets have more formatting options for comments, but Excel notes stay straightforward.
What happens to notes if I delete the cell?
The note is deleted along with the cell. If you delete a cell by mistake and undo the action right away with Ctrl+Z, the note comes back. If you delete the cell and then do other work, the note is gone permanently.
Can I search for text inside notes?
Excel's Find function does not search inside notes. You have to manually look through cells with red triangles to find the note you want. If you need to search through notes, you might want to keep a separate list of what each note says.
Do notes work the same way in Google Sheets?
Google Sheets calls them "comments" instead of "notes," and they work slightly differently. In Google Sheets, right-click a cell and select Add a Comment. You can format the text and have conversations with other people in the comments. The basic idea is the same, but the features are not identical.
Can I see all the notes in my spreadsheet at once?
Excel does not have a built-in way to list all notes in one place. You have to hover over cells with red triangles to see what each note says. If you need a summary of all notes, you would have to read through them manually or create a separate list by hand.