How to Reverse the Order of Excel Comments and Replies
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.

- 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.
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.
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.
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'.
Open a word processor like Microsoft Word or a simple text editor like Notepad. Paste the copied conversation into the blank document.
Rearrange the text manually by cutting and pasting the most recent replies to the top of the document.
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.

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. Download and Install WPS Office: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx file containing the threaded comments.
- 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.

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.




