Office Settings & Configuration

How to Reverse the Order of Excel Comments and Replies

Steve KSteve K Nov 11, 2026 870 views

Question details

The user wants to display the most recent replies at the top of a threaded comment in Excel instead of viewing the oldest comments first.

How to Reverse the Order of Excel Comments and Replies
Product
Microsoft Excel
Device & OS
not provided
Scenario
Reviewing and collaborating on a shared spreadsheet where long conversation threads are present.
Observed behavior
Excel displays threaded comments chronologically with the oldest comments at the top and the newest replies at the bottom.
Before you start

Keep in mind that modern threaded comments in spreadsheet applications are designed to mimic standard chat logs, meaning they naturally read from oldest to newest.

Solution 1Recommended

Manual Export and Reorganization Workaround

Since Excel lacks a built-in feature to reverse comment order, you must manually copy the conversation into a text editor if newest-first viewing is strictly required.

Microsoft Excel does not currently provide a standard option to change the sorting order of threaded comments. To view them in reverse chronological order, the text must be exported and manipulated externally.

1
Copy the Threaded Comment

Select the cell containing the comment thread. Click on the comment icon to open the thread, highlight the text of the entire conversation, right-click, and select 'Copy'.

2
Paste into a Text Editor

Open a word processor like Microsoft Word or a simple text editor like Notepad. Paste the copied conversation into the blank document.

3
Manually Reorder Replies

Rearrange the text manually by cutting and pasting the most recent replies to the top of the document.

4
Save or Re-insert as a Note

Keep the text in the external document for reference, or paste the newly ordered text back into Excel as a static 'Note' rather than a threaded comment.

Manual Export and Reorganization Workaround
Feature Limitation: Currently, Microsoft Excel does not offer a built-in toggle to reverse the chronological order of threaded comments. If this feature is critical, consider utilizing third-party collaboration trackers.
Free Microsoft Office alternative

Use WPS Office for Seamless Spreadsheet Collaboration

If you are dealing with Microsoft Office feature limitations, try WPS Office. It provides a free, lightweight, and highly compatible alternative for handling spreadsheets, reviewing comments, and collaborating effortlessly.

  1. 1. Download and Install WPS Office: Visit the official WPS Office website to download the free suite and install it on your device.
  2. 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx file containing the threaded comments.
  3. 3. Manage Your Comments: Navigate to the 'Review' tab on the top ribbon to easily view, edit, and navigate through all comments left by your team.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsFree, lightweight, and fast to installFamiliar user interface ensures a seamless migrationRobust review tools for adding and managing spreadsheet comments
microsoft office alternative - wps office

Frequently Asked Questions

Can I sort Excel comments by date across the entire workbook?

No native feature allows you to sort a list of all comments strictly by date. However, you can use the 'Review' tab and click 'Next' or 'Previous' to navigate sequentially through the comments as they appear in the worksheet.

Is there a macro (VBA) to reverse the comment order?

VBA can be used to extract the text of threaded comments into standard worksheet cells where you can manipulate them. However, VBA cannot reverse the internal display order of Excel's native threaded comment interface.

What is the difference between Notes and Comments in Excel?

Notes are the traditional, static annotations used to leave plain text reminders in a cell. Comments are modern, threaded conversations that allow multiple users to reply to one another with timestamps.