Share via

Excel - the Sort function is disabled

Anonymous
2024-05-13T21:10:43+00:00

The Sort function is grayed out and I cannot sort. The sheet and workbook are not password protected. I somehow got the rows to be alternately light and dark today, but don't know how. Ideas?

Microsoft 365 and Office | Excel | For home | Windows

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

Answer accepted by question author

Shakiru Soenu 755 Reputation points
2024-05-13T22:19:47+00:00

Hi W-Wolfe!

I'm Shakiru, an Excel User and I'm glad to help you out today

Does this issue occur only with this file or all Excel files?

Since the sheets or workbooks are not protected then, verify if the sheets are grouped or merged.

If it only happens in a particular file, copy and paste the content into a new or blank file.

Let me know how it goes.

Best Regards

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-13T23:31:22+00:00

    I created a second copy as you suggested and that worked. Thanks

    Was this answer helpful?

    0 comments