Office Settings & Configuration

How to Find Comments and Notes in an Excel Worksheet

Phi Hung VoPhi Hung Vo Nov 10, 2026 868 views

Question details

The user wants to locate and navigate through both legacy notes and modern threaded comments in an Excel worksheet.

How to Find Comments and Notes in an Excel Worksheet
Product
Excel
Device & OS
not provided
Scenario
Reviewing or editing an Excel spreadsheet containing feedback, notes, or threaded discussions.
Observed behavior
Excel separates legacy Notes from threaded Comments. The 'Go To Special' feature only selects Notes, leaving users unsure how to navigate threaded comments.
Before you start

Determine whether you are looking for modern threaded comments (used for discussions) or legacy notes (used for static annotations), as Excel handles them differently.

Solution 1Recommended

Use the Review Tab to Navigate and Show Comments

The easiest way to view all modern threaded comments in your worksheet is through the dedicated Comments pane on the Review tab.

Modern Excel treats comments as threaded conversations. Because of this, they are no longer selected using the traditional 'Go To Special' method. Instead, Microsoft provides a dedicated pane to read, reply to, and navigate these discussions.

1
Open the Review tab

Open your Excel workbook and click on the 'Review' tab in the top ribbon.

2
Show the Comments pane

Click on 'Show Comments' in the Comments group. This will open the Comments pane on the right side of the screen, displaying all comments for the current worksheet.

3
Navigate through comments

Alternatively, click 'Next Comment' or 'Previous Comment' in the Review tab to jump sequentially from one comment to the next across the worksheet.

Use the Review Tab to Navigate and Show Comments
Comments vs Notes: This method works specifically for modern threaded comments, which allow user replies, rather than legacy yellow sticky notes.
Manage Spreadsheets Efficiently

How to Find and Manage Comments in WPS Spreadsheet

WPS Office provides an intuitive and seamless way to view, add, and navigate through comments and notes in your spreadsheets. It is fully compatible with Microsoft Excel file formats, ensuring your collaborative work is never lost.

  1. 1. Open your file: Launch WPS Spreadsheet and open the document containing the comments or notes.
  2. 2. Go to the Review tab: Navigate to the 'Review' tab located on the top ribbon.
  3. 3. Navigate comments: Use the 'Next' and 'Previous' buttons in the Comments section to quickly jump between cell annotations.
Fully compatible with Microsoft Excel (.xlsx, .xls) comment formats.Intuitive Review tab for easy comment navigation and management.Free, lightweight, and fast office suite for Windows, Mac, and Linux.
microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between Notes and Comments in modern Excel?

In modern Excel, 'Comments' refer to threaded conversations where multiple users can reply to each other. 'Notes' (previously called comments in older versions) are static, yellow sticky notes used for adding simple annotations to a cell without reply functionality.

Can I convert legacy notes into threaded comments?

Yes, you can convert notes to threaded comments by right-clicking the cell containing the note and selecting 'Convert to Linked Comment' or a similar option, depending on your exact Excel version.

Why does Go To Special only select notes and not comments?

The 'Go To Special' feature was originally designed for the older annotation system (now called Notes). When Microsoft introduced threaded comments, they were separated into their own pane system, so 'Go To Special' only targets the legacy note objects.

How can I print comments and notes in Excel?

Go to the Page Layout tab, click the dialog launcher icon in the Page Setup group, navigate to the Sheet tab, and use the 'Comments and notes' dropdown to choose how you want them printed (e.g., 'At end of sheet' or 'As displayed on sheet').