Stop Excel Comments Opening When Double-Clicking a Cell in WPS Spreadsheets
Question details
The user wants to understand why double-clicking a cell that contains a comment or note opens the comment editor, and how to follow a formula reference instead of opening the comment.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working in a workbook and double-clicks a cell expecting to edit the cell or jump to a formula source, but the comment editor appears.
- Observed behavior
- Double-clicking a cell with a comment or threaded note opens the comment editor. This is built-in behavior, and formula reference navigation requires a keyboard shortcut such as Ctrl+[.
Open the workbook in WPS Spreadsheets and identify whether the target cell contains a legacy comment or a threaded note. Keep the Review tab available if you need to edit or hide comments after navigating.
Use Ctrl+[ to Jump to a Formula Source Cell Instead of Opening the Comment
Use this when you need to follow a formula reference in a cell that also contains a comment or note.
Double-clicking a commented cell is designed to open the comment editor, not to follow formula references. WPS Spreadsheets supports the Excel-compatible shortcut Ctrl+[ to select the first direct precedent cell.
Open your workbook in WPS Spreadsheets and click once on the cell that contains the formula reference you want to follow.
Press and hold Ctrl, then press the [ key. WPS Spreadsheets jumps to the first precedent or source cell referenced by the formula.
Use Ctrl+] to select dependent cells, or click the original cell again if you need to return to the formula cell.
Edit the Cell Content with F2 or the Formula Bar to Avoid Opening the Comment
Use this when you want to edit the cell value but keep the comment or note closed.
Try Ctrl+F10 for Expected Navigation Behavior in Some Excel Versions
Use this as an alternative navigation shortcut if Ctrl+[ does not match the behavior you expect in your version.
Follow Formula Precedents Without Opening the Comment Editor in WPS Spreadsheets
WPS Spreadsheets keeps your Excel-compatible workflow intact: select the formula cell and press Ctrl+[ to jump to its source cell instead of opening the comment editor when you double-click a commented cell.
- 1. Open your workbook: Launch WPS Office and open the Excel-compatible workbook in WPS Spreadsheets.
- 2. Select the formula cell: Click once on the cell that contains the formula reference you want to follow.
- 3. Press Ctrl+[: Press Ctrl+[ to jump to the direct precedent or source cell without opening the comment editor.
- 4. Edit without opening comments: If you need to edit the current cell, press F2 or click inside the formula bar and make your changes.
Frequently Asked Questions
Why does double-clicking a cell with a comment open the comment editor?
This is built-in behavior for cells that contain a legacy comment or threaded note. Excel and WPS Spreadsheets interpret a double-click on a commented cell as the action to open and edit that comment.
How do I follow a formula reference when the cell has a comment?
Select the cell and press Ctrl+[. This jumps to the first direct precedent or source cell without opening the comment editor. In some versions, Ctrl+F10 may also work.
Can I turn off the comment editor that opens on double-click?
There is no dedicated setting to disable the comment editor for double-clicking a commented cell. To edit the cell content, select the cell and press F2 or click inside the formula bar instead.
How do I edit a cell that contains a comment without opening the comment?
Click the cell once, then press F2 or click inside the formula bar. Make your changes and press Enter; the comment stays closed.
What is the difference between working with a comment and a note in this case?
Both legacy comments and threaded notes can open in the editor when you double-click the cell. The same shortcuts apply for editing the cell content with F2 or following formula references with Ctrl+[.
