Question: I am trying to sort a column alphabetically but the Excel Sort and Filter icon is grayed out. How do I reactivate the icon?
How to Fix Excel Sort and Filter Icon Grayed Out
The most common reason why the Sort and Filter icon is grayed out in Excel is because multiple sheets are selected. If this is the case, you will notice that more than one sheet is active at the bottom of the screen.
To ensure that you have only one active sheet in order to enable Soft and Filter icon, right click on the sheets and click on Ungroup Sheets. The Sort and Filter icon will now become active.
Another reason why the Sort and Filter icon is grayed out is because a part of your data is within a table and the other part is not. In this case, the Sort and Filter icon will be grayed out and Excel will not allow you to sort the data.
Consider extending your table to include the data which is outside the table or sort the additional data in a separate column.
Yet another reason for the Sort and Filter icon to be disabled is because the Sheet is protected. A Sheet can be unprotected by going to Review Tab and then clicking on Unprotect Sheet. The Sort and Filter icon is not affected if the Workbook is protected though.