I am facing excel sorting issue

Question

Hi All

Sorting feature is not working properly on my excel sheet. I have tried installing latest windows updates, performed a quick repair, checked for office updates, reinstalled the Office, But the issue persists.

I can only sort the data from A-Z but not Z-A,

Answer 1

If issue with Excel, you may open register editor and locate the Options registry key and delete it to reset Excel settings.

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options

Disclaimer: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Edit at your own risk.

Answer 2

I tested the file on a different machine. Sorting works fine there. I am assuming it as a local pc Issue.

Answer 3

You may upload file in private message.

Private Messages - Microsoft Community

Answer 4

I dont trust sharing the link from my one drive. Can I upload the file directly

Answer 5

Could you share a test file to reproduce your issue? Then I can help you correct it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.  *Please make sure you have removed any sensitive or private information in the sample file before uploading.