Excel Sort and Filter Icon is Grayed Out [Fixed]

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?

excel sort and filter icon grayed out

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.

data-tab-2-sheets-selected

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.

excel sort and filter icon grayed out data outside table

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.

16 thoughts on “Excel Sort and Filter Icon is Grayed Out [Fixed]”

  1. None of these reasons apply. I normally have no trouble using sort or filter in Excel 2016. I was given a spreadsheet today that I would like to add filters to and probably sort. As long as I don’t have any entire columns or rows selected, they are not greyed out, but as soon as I select any column or any row, they are. I have verified that multiple worksheets are not selected and that the worksheet is not protected.

    1. Please see if your data is being pulled from an external source. This would cause the sort and filter to be disabled.

  2. Thanks. That could have been it. I solved it by copying the data to a new tab using the option to copy only the data.. That worked.

  3. I found the same as Deborah Arndt i.e. had to copy workbook to a new workbook, by selecting all cells and pasting values / format only

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top