Fix Excel Notes That Disappear When Editing
Question details
The user needs to troubleshoot Excel notes that disappear or cannot be edited normally.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The workbook contains notes on cells, but selecting Edit Note does not open the expected editor. The note becomes editable only after repeatedly using Show/Hide Note.
- Observed behavior
- Notes disappear or behave incorrectly when Edit Note is selected, potentially because of mixed note types, workbook corruption, protection, hidden content, add-ins, or version differences.
Select an affected cell and check the Review tab to determine whether Excel identifies it as a Note or a threaded Comment. Also record the Excel edition and version from File > Account, or check whether you are using Excel for the web.
Identify the note type and check workbook display settings
Use this first when Edit Note behaves differently from Show/Hide Note or when the workbook mixes traditional notes with threaded comments.
Excel treats traditional Notes and modern threaded Comments as different features, with separate editing commands. Hidden rows or columns, sheet protection, and display settings can also make notes appear to disappear.
Select the affected cell, open the Review tab, and check whether the available command is Edit Note or Edit Comment. Use the command that matches the annotation type.
On the Review tab, select Notes, then choose Show/Hide Note or Show All Notes. Check whether the note becomes visible before selecting Edit Note.
Open the Review tab and select Unprotect Sheet if available. Then use Home > Format > Hide & Unhide to reveal hidden rows or columns that may contain the affected cells.
Open File > Account in desktop Excel and review the product information. If using Excel for the web, open the workbook in desktop Excel to compare the note behavior.
Test the workbook for corruption or add-in interference
Use this when notes work in other files but fail in one workbook or when Excel behaves inconsistently across sessions.
Recreate affected notes in a new worksheet
Use this workaround when only one workbook, worksheet, column, or group of cells is affected and the notes fail in the original file.
Switch to WPS Office for familiar spreadsheet note editing
If the issue is specific to Microsoft Excel, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong compatibility for common Excel workbooks. Open a copy of the file in WPS Spreadsheets to continue editing and compare the result without changing the original workbook.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application launcher.
- 2. Open the Excel workbook: Choose Menu > Open, select the XLS or XLSX workbook, and allow WPS Spreadsheets to load a copy of the file.
- 3. Review the affected cells: Use the spreadsheet review and annotation tools to inspect the affected cells, then compare the workbook behavior with Microsoft Excel.

Frequently Asked Questions
How can I tell whether an Excel cell has a Note or a threaded Comment?
Select the cell and open the Review tab. Excel shows commands such as Edit Note for traditional notes or Edit Comment for modern threaded comments; these annotation types use different editing workflows.
Why does Show/Hide Note work when Edit Note does not?
The workbook may have display or protection settings, hidden rows or columns, version differences, add-in interference, or file corruption. Test the cell in a blank workbook and in Excel Safe Mode to narrow down the cause.
Can sheet protection prevent Excel notes from being edited?
Yes. Open the Review tab and select Unprotect Sheet if the command is available. A password may be required before note-related actions can be changed.
What should I do if notes fail only in one Excel workbook?
Create a new worksheet or workbook, copy the affected data without the notes, and recreate the notes with Review > Notes > New Note. Save the result under a new filename and test it after reopening.
Could an Excel add-in cause notes to disappear?
It is possible. Close Excel, start it with excel /safe from the Windows Run dialog, and test the workbook. If the issue disappears, disable COM add-ins through File > Options > Add-ins and re-enable them one at a time.




