Share via

How to undo sort after saving

Anonymous
2022-06-09T19:06:03+00:00

Hello,

I was working on a spreadsheet, and sorted the data first by 'largest to smallest' before saving the document. When I opened it again, I tried to sort it by 'A-Z' to get back to the original order--I didn't undo the 'A-Z' sort, and I believe I saved the document again. Now, the data order is off. 

I didn't include a reference/index column before sorting. 

I already tried to clear the sort, but the clear button is greyed out.

I can't undo any of these actions

The version of Excel I am working with won't allow me to access File, Manage workbook, View, and Restore Previous Version. 

I also can't access File, Info, Version History, and restore a version. 

I was working with autosave off, and I can't find the autorecovery folder on my computer using the thread : '/Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft' 

'Browse version history' is also greyed out on the spreadsheet.

Is there anything else I can try to restore the original order?

Microsoft 365 and Office | Excel | For education | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-10T00:14:46+00:00

    Sorry there is no way of "undoing" the sort after saving.

    .

    Your only option is to find an older copy of the file before it was saved.

    2 people found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-06-10T20:55:30+00:00

    Hi

    AutoSave would have solved the problem for you. AutoRecover is available only when you save your files to OneDrive or SharePoint.

    AutoRecover does not come into play here. Excel did not quit unexpectedly nor did you force-quit Excel. Those are the only times there is an AutoRecover file to recover.

    Time Machine would also solve the problem if you saved your file to your local Mac directory.

    Learn how to use Time Machine to restore specific files

    If you saved your file somewhere else, the technology that applies to the device, cloud, or network storage location is what you would use to recover a previous version.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-06-09T21:45:26+00:00

    Dear Amir,

    Thank you for posting in Microsoft Community.

    I understand that you want undo sort after saving. I found an article related to your query. Kindly check the article below.

    How do I recover a previous version of an excel file on a mac? - Microsoft Community

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    Hope the suggestion can help you.

    We look forward to your response. Thanks for your cooperation. Stay safe and healthy always.

    Sincerely,

    Zee | Microsoft Community Moderator

    0 comments