Office Settings & Configuration

Fix WPS Spreadsheet Notes That Cannot Be Edited and Show a Line

Amos GikundaAmos Gikunda Nov 13, 2026 869 views

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

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.

Solution 1Recommended

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.

1
Select the entire sheet

Click the triangle at the intersection of the row numbers and column letters, or press Ctrl+A to select all cells.

2
Unhide hidden rows and columns

On the Home tab, open Format > Hide & Unhide, then choose Unhide Rows and Unhide Columns.

3
Show all notes or comments

Go to the Review tab and click Notes > Show All Notes. If your WPS version uses modern comments, click Comments > Show All Comments instead.

4
Resize and move the affected note

Click the note border, use the white sizing handles to resize it, then drag the note box back to the cell it should annotate.

5
Confirm the note opens for editing

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.

Unhide all rows and columns, show all notes, and reposition the misplaced note
Notes are editable again: Once all rows and columns are visible and notes are shown, the misdirected line usually disappears and the note can be resized and dragged back into place.

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. 1. Download WPS Office: Download and install WPS Office from the official WPS website, then open your workbook in WPS Spreadsheets.
  2. 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. 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. 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.
Resize and reposition misplaced notes from the familiar Review tabOpens, edits, and saves Excel .xlsx and .xls files without losing notes or commentsFree and lightweight spreadsheet tools with a Microsoft Office-like interfaceSupports legacy Excel notes and modern threaded comments for easier troubleshooting
microsoft office alternative - wps office

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.