How to insert, delete, and bulk delete notes in Excel
In Excel for Windows, right-click a cell and choose New Note, or press Shift+F2. To remove one, choose Delete Note. Before clearing several cells at once, check for threaded comments because the combined clear command removes both types of annotation.
Add and edit a cell note
- Select B2 to add an explanation, then press Shift+F2 or choose New Note from its right-click menu. Older versions may show a different label.
- Type a note such as “Amounts in dollars” and click outside the box. To revise it later, select Edit Note.
- If the box is too small, select its edge and drag a sizing handle. Moving the box leaves it attached to B2.
Use Notes on the Review tab to control visibility. In Microsoft 365, notes attach simple annotations to cells, while threaded comments support replies.
Microsoft Support instructions for adding notes and comments
Format note text and its box
- Open the note for editing and right-click its outer border to open the formatting command. Clicking inside the text can show a different menu.
- Set the font and size. Depending on the version, you may also be able to change the fill and border. Check that the edge of the box is selected if an option is missing.
Check that the text stands out against the background. Write important conditions in the note so readers do not have to rely on color alone.
Microsoft Support guide to formatting legacy worksheet notes
Delete one note
- Right-click the cell with the note and choose Delete Note. The value or formula remains. The Delete key can clear cell contents, so use the note command instead.
Show/Hide only changes whether the box appears. After deletion, check that the note marker has gone and the cell contents remain.
Clear several notes on one sheet
- In a copy, select the range you want to clean up. For separate cells such as B2, D3, and C5, hold Ctrl as you select them. Check whether the selection contains comments you need to keep.
- If the selection has only notes, or both kinds should go, choose Home > Clear > Clear Comments and Notes. In older versions, a Delete Note command can appear when you right-click a multi-cell selection, as shown in the Korean screenshots.
- Check that the notes are gone and the values and formulas are intact. Select a new range on each worksheet you need to clean.
Microsoft Support guide to clearing comments and notes
Keep threaded comments when removing notes
If notes and threaded comments are mixed and the comments should stay, use Delete Note on the individual cells with notes. Before sharing a copy, look for personal information in notes that are still hidden.




