Office Settings & Configuration

Fix Excel Notes That Disappear When Editing

Steven ParkerSteven Parker Nov 12, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Confirm the annotation type

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.

2
Show the note explicitly

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.

3
Check protection and hidden content

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.

4
Check the Excel version

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.

Notes and Comments are different: Traditional Notes are the successor to legacy cell comments, while threaded Comments support conversations. Their Review tab commands and editing behavior are not interchangeable.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application launcher.
  2. 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. 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.
Lightweight spreadsheet editor for reviewing and editing workbook contentFamiliar ribbon-style interface that makes common formatting and review tools easy to findSupports Microsoft Excel XLS and XLSX file formats for smoother migrationUseful for testing whether a note or workbook issue is specific to ExcelHelps continue spreadsheet work without requiring a Microsoft 365 subscription
microsoft office alternative - wps office

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.