To delete a note in Excel for Microsoft 365 on Windows, right-click the cell containing it and choose Delete Note. The note disappears, but the cell’s value, formula, and formatting stay in place. If you need to remove notes from several cells, select the range and use Home > Clear > Clear Notes. First make sure the item is a note, not a threaded comment, because Excel handles those separately.
What You’ll Need
- An Excel workbook that you can edit. If it is read-only or protected, you may need permission or to unprotect the sheet before changing notes.
- Access to the worksheet and the cell or range where the note is stored. If you are unsure which cell has a note, look for the note indicator or use Excel’s note display options.
- For a shared or important workbook, consider saving a copy before removing many notes. A single deletion can usually be undone, but a backup gives you another way to recover if you make broader changes.
Step-by-Step
- Check that the item is a note. Select the cell and look at the item that appears, or hover over its indicator. Notes are the older, often yellow, cell annotations that can be edited by one person. Threaded comments are designed for conversations and replies. Microsoft 365 may show both features, and their appearance can differ by version or workbook settings. If the pop-up has a reply field or a conversation thread, it is a comment rather than a note; see the FAQ below for the right removal command.
- Find the cell with the note. Click the worksheet tab where you expect the note to be, then locate the marked cell. A small marker in a cell corner commonly indicates that it has an annotation, although its color can vary. If you cannot see markers, use Review > Notes > Show All Notes on Windows to display notes and check their positions. Click Show All Notes again when you want to hide them. If the Notes commands are not visible, check the Review tab for a Notes menu or dropdown.
- Select the cell itself. Click once on the cell that owns the note. Do not click inside the note box and start selecting its text: the deletion command applies to the selected cell. If the note is open and covers nearby cells, click the cell border or press Esc to close the pop-up, then select the cell. Confirm the Name Box to the left of the formula bar shows the address you intended, such as C5.
- Delete the note using the context menu. Right-click the selected cell and choose Delete Note. Excel removes the note from that cell. The cell’s contents are not deleted or changed by this command. On a Windows laptop with a touchpad, a two-finger tap or click may open the context menu; the exact gesture depends on your device settings. If the menu says Delete Comment instead, check whether you selected a threaded comment rather than a note.
- Alternatively, use the Review ribbon. With the cell selected, open Review, find the Notes controls, and choose Delete Note. Some ribbon layouts place note commands inside a dropdown, so open the Notes menu if the button is not shown directly. This method is useful when you prefer the ribbon or when the context menu is difficult to use. Make sure the correct cell remains selected before you click the command.
- Confirm the note is gone. Click another cell, then return to the original cell or hover over its marker area. The note should no longer appear, and the cell’s value or formula should remain. If you had all notes displayed, the deleted note’s box should disappear. Save the workbook if you want to keep the change; if AutoSave is enabled, Excel may save it automatically.
- Remove notes from a range when needed. To clear notes from multiple cells, select the specific range or worksheet area you want to clean, then choose Home > Clear > Clear Notes. This removes notes in the selection while preserving cell values and formatting. It is different from Clear All, which removes much more than notes. Check the selected range carefully before using Clear Notes, especially if the worksheet contains annotations you want to keep.
- Undo immediately if you chose the wrong cell or range. Press Ctrl+Z on Windows right after the deletion, or use the Undo button on the Quick Access Toolbar. Confirm that the note returns before continuing. Undo availability can depend on what you did afterward and how the workbook is being edited or saved, so do not treat it as a substitute for checking the selection first.
Common Mistakes
- Choosing Delete instead of Delete Note. The keyboard Delete key, or the Delete command for cell contents, can clear values while leaving a note behind. Use the specific Delete Note command for one cell or Clear Notes for a selected range.
- Confusing a comment with a note. A threaded comment supports replies and discussion. If you open its menu and do not see Delete Note, you may be dealing with a comment. Use the comment’s own delete option instead; deleting a note will not remove a threaded comment.
- Selecting the wrong cell or too large a range. Notes can be easy to miss when a sheet is zoomed out or filtered. Check the active cell address, and for range cleanup, inspect the selection borders before using Clear Notes.
- Using Clear All to get rid of annotations. Clear All can remove cell contents, formatting, and other features. It is excessive if you only want to remove notes. Choose Clear Notes from the Clear menu instead.
- Assuming a hidden note has already been deleted. Hiding a note or turning off its display does not remove it. If you only want a cleaner view, hide it; if you want it gone, use Delete Note or Clear Notes.
Tips
- Keep a record before bulk cleanup. Notes may contain instructions, explanations, or context that is not repeated elsewhere. If you are unsure whether you will need them, save a separate copy of the workbook before clearing a large range.
- Use the narrowest selection possible. If only a few notes are unwanted, delete them cell by cell. If many notes need removal, select just the relevant table or worksheet region rather than the entire sheet.
- Separate removal from display settings. Show All Notes is useful for reviewing annotations; it does not delete or edit them. Use it to inspect the worksheet, then apply the deletion command only when you have identified the notes to remove.
- Check the workbook after saving. If the file is shared, confirm the change is saved and that you are editing the intended copy. In a shared workbook, another editor may make changes at the same time, so verify that the note remains deleted after syncing.
- Know the platform differences. In Excel for Mac, select the cell and use its context menu’s Delete Note command, or look for the note controls on the Review tab. On Excel for the web, right-click the cell and choose the note deletion option when available. Ribbon labels and layouts can vary slightly by platform and update, but the key is to remove the note attached to the selected cell rather than clear the cell itself.
Troubleshooting
Delete Note is missing from the menu. First verify that the selected cell contains a note, rather than a threaded comment or no annotation at all. Try selecting the cell and opening Review to find the Notes controls. If the item is a threaded comment, open its menu and use the comment deletion command instead. If the workbook is protected, the command may be unavailable until the sheet is unprotected.
The note seems to remain after deletion. Click another cell and return to the original one; a note box that was already open may not close immediately. Check whether a second note is in a nearby cell, or whether the visible item is actually a comment. You can use Review > Notes > Show All Notes to inspect notes across the sheet. If the note is still attached to the selected cell, repeat Delete Note and then save.
The cell’s value disappeared too. Press Ctrl+Z immediately on Windows, or select Undo, to restore the previous state if the action is still in the undo history. Then select the cell again and use Delete Note, not the Delete key or a command that clears cell contents. If undo is unavailable, restore the workbook from a saved copy or version history if your storage service provides one.
You cannot edit the worksheet. Check whether the workbook opened in read-only mode, whether you have editing permission, or whether worksheet protection is enabled. If you are authorized, use Review > Unprotect Sheet and provide the password if prompted. Do not attempt to bypass protection; ask the workbook owner for access if you do not have permission.
The ribbon commands are hard to find. Excel’s ribbon can be simplified or collapsed. Expand it, select the Review tab, and look for Notes or a dropdown that contains note commands. You can also use the cell’s right-click menu as a direct alternative. If you are in Excel for the web or Mac, expect a slightly different layout and use the selected cell’s context menu if the ribbon path is not obvious.
Frequently Asked Questions
Does deleting a note delete the cell’s data?
No. The Delete Note command removes the annotation only. The cell’s value, formula, and formatting remain. Avoid the Delete key or Clear All if you want to keep the cell unchanged.
What is the difference between a note and a comment in Excel?
Notes are older annotations, often used to add a simple explanation to a cell. Comments in current Excel are threaded conversations with replies. The two features have separate menus and deletion commands, so identify the type before removing it.
Can I delete notes from several cells at once?
Yes. Select the range that contains the notes, then use Home > Clear > Clear Notes. This clears notes from the selection without clearing its contents. Carefully check the range so you do not remove notes you meant to keep.
Can I recover a note after deleting it?
Press Ctrl+Z on Windows immediately after deletion, or click Undo. If you have continued editing, closed the file, or cannot undo, recovery may depend on a saved copy or available version history. Save a backup before bulk cleanup if the notes matter.
Does hiding a note delete it?
No. Hiding only changes whether the note is displayed; it remains attached to the cell. Use Delete Note to remove one, or Clear Notes to remove notes from a selected range.
How do I delete a note in Excel for Mac or the web?
On Mac, select the cell and choose Delete Note from its context menu or the Review tab’s note controls. In Excel for the web, use the selected cell’s right-click menu and choose the note deletion option if shown. The layout can differ, but delete the annotation rather than the cell contents.
Related
- Copy and Paste in Excel While Keeping Formatting
- Copy and Paste Split Cells in Excel: A Practical Guide
- How to Copy and Paste Bullet Points in Excel Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Limit a Range in Google SheetsTo limit who can change cells in Google Sheets, select the cells, open Data > Protect sheets and…
- Excel Column to Comma-Separated List: Easy MethodsIf your values are in A2:A20, enter =TEXTJOIN(", ",TRUE,A2:A20) in an empty cell to turn the column into…
- How to Add Page Numbers in Word for MLA Style CorrectlyTo add MLA-style page numbers in Microsoft Word, insert an automatic page-number field in the top-right header, then…
- Excel Table Absolute References: How They WorkExcel tables do not use dollar signs to make structured references absolute: a reference such as Orders[Amount] continues…
- Excel: Sum Filtered Rows with SUBTOTALTo sum only the rows currently visible after filtering in Excel, use SUBTOTAL with function number 109: =SUBTOTAL(109,B2:B100).…
- Excel Data Validation: Add Criteria and RulesTo add criteria in Excel Data Validation, select the cells, go to Data > Data Validation > Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.