Excel sort function doesnt work!

Question

Hello,

I cannot perform the sorting function in the Excel program I am using; as you can see in the screenshot below, there is a function bar appearing at the bottom right corner when I try to sort any data, and it is not sorting. However, if I create a pivot table from the data on the page, the sorting function works on the pivot table. Can you help me solve this issue?"

![](https://learn-attachment.microsoft.com/api/attachments/d2ee6ff7-3928-4839-8584-c5f833bba78b?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/a1c84cb9-9fc5-4291-b830-c5214374c2e7?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">![](https://learn-attachment.microsoft.com/api/attachments/a1c84cb9-9fc5-4291-b830-c5214374c2e7?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/4f3fe5c8-42a7-4805-9126-593904b2aede?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">![](https://learn-attachment.microsoft.com/api/attachments/4f3fe5c8-42a7-4805-9126-593904b2aede?platform=QnA

Answer 1

The issue is not with the file. Even when I try in different files or create a new Excel file, the sorting function doesn't work at all. I believe I am experiencing a user-specific issue because when I try it with a different Office user on the same computer, the sorting function works without any problems.

Answer 2

a) Select a cell inside the data, then try again.

b) Looks like there is a table in the sheet, try to click the drop down buttons in row 1, in there is a sort feature too.

If you need further help, we need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.