Fix WPS Spreadsheet Notes That Cannot Be Edited and Show a Line
Question details
The user needs to fix a WPS Spreadsheet note or Excel comment that will not open for editing and draws a connector line to an unexpected location, often when rows or columns are hidden.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Editing or repositioning a misplaced note or comment in a workbook with hidden rows or columns, or after the note becomes damaged.
- Observed behavior
- The note does not open for editing from the right-click menu and shows a line extending to an unintended area. Unhiding rows and columns and showing all notes makes the misplaced note visible and resizable.
Make sure the workbook is in an editable format and confirm whether the file uses legacy notes or modern threaded comments. If the sheet is protected, remove protection before trying to edit or move notes.
Unhide all rows and columns, show all notes, and reposition the misplaced note
Use this first when a note draws a line to an unexpected location or cannot be edited, especially if hidden rows or columns are present.
Hidden rows and columns can change where a note's connector line points, making the note appear detached from its cell. Showing all notes reveals the note box and its sizing handles so you can move it back.
Click the triangle at the intersection of the row numbers and column letters, or press Ctrl+A to select all cells.
On the Home tab, open Format > Hide & Unhide, then choose Unhide Rows and Unhide Columns.
Go to the Review tab and click Notes > Show All Notes. If your WPS version uses modern comments, click Comments > Show All Comments instead.
Click the note border, use the white sizing handles to resize it, then drag the note box back to the cell it should annotate.
Right-click the annotated cell and choose Edit Note or Edit Comment to verify that the note is editable and the connector line points to the correct cell.

Reopen the workbook or copy the worksheet when the note remains uneditable
Use this if the note still will not open after unhiding and showing all notes, which may mean the note object is damaged.
Fix Uneditable Notes in WPS Office Spreadsheets
Use WPS Office Spreadsheets to reveal, resize, and reposition misplaced notes, then save the workbook in an Excel-compatible format without losing note data.
- 1. Download WPS Office: Download and install WPS Office from the official WPS website, then open your workbook in WPS Spreadsheets.
- 2. Open the Review tab: Click the Review tab and use Notes > Show All Notes or Comments > Show All Comments to reveal misplaced or hidden note boxes.
- 3. Resize and move the note: Select the note, drag it back to the intended cell, and use the white sizing handles to resize it.
- 4. Save as an Excel-compatible format: Press Ctrl+S or use Menu > Save As to save the workbook as .xlsx to preserve compatibility with Microsoft Excel.

Frequently Asked Questions
Why does my Excel note show a line to another cell and not open for editing?
Hidden rows or columns can misdirect the note connector line and prevent the note from appearing where expected. Unhide all rows and columns, then go to Review > Notes > Show All Notes and move or resize the note.
How do I unhide all rows and columns in WPS Spreadsheets?
Click the triangle at the top-left corner of the sheet to select all cells, then go to Home > Format > Hide & Unhide and choose Unhide Rows and Unhide Columns.
Does WPS Spreadsheets support legacy Excel notes and modern comments?
Yes. WPS Spreadsheets works with both legacy notes and modern threaded comments. Check the Review tab to see whether your file uses Notes or Comments tools.
What can I do if the note still will not open after unhiding rows and columns?
Save and close the workbook, then reopen it. If the note still cannot be edited, delete the damaged note, copy the worksheet to a new workbook, and add a new note.
Can I edit Excel files with comments in WPS Office without losing them?
Yes. WPS Office opens, edits, and saves .xlsx and .xls files while preserving notes and comments, so you can fix misplaced notes without losing existing annotations.




