Why is filter greyed out excel

However, the 'remove filter' option is greyed out Many thanks, Mark. Re: Remove filter greyed out by acknak » Tue Mar 03, pm A filter only applies to a specific range of cells.

As long as the active cell cursor is within that range, the "Remove Filter" function should be available. If you started the filter at the top of a column, try going back there to remove it. Re: Remove filter greyed out by markbolton » Tue Mar 03, pm thanks a lot I still couldnt get the filter to stop being greyed, but the show Row option worked OK.

Thank you very much, Mark. Re: Remove filter greyed out by Villeroy » Tue Mar 03, pm The problem is that you always need a database range for all operations related to sorting, filtering and subtotals. Recent Articles. Yes, this is exactly the process shown above, converting a Table into an ordinary Range. This is just what I needed. Never realized that before but it makes sense.

Thank you!! Worked in Excel for years and this was driving me nuts! Hi Meg, It looks like you were having the problem mentioned in the The data may be partially contained within a Table section above. Hi Michael, The only explanation I can think of is that you might have had the extra sheets selected without realizing it, giving you the problem described in the A worksheet group may be selected section above.

This has been my bane for such a long time. Your solution worked easy. Thanks Simon Smart! Leave a Reply Cancel reply Your email address will not be published. Comment Name Email. Excel Tutorials. Which tutorial do you need? Essential Skills. Expert Skills. Which Excel Essential Skills version do you need to learn?

Excel for Windows. Tell Me More about this title. E-Book Instant Download. Otherwise, the error may hinder your Excel application to apply the filter. The best option for clearing up all the Excel filters is by tapping to the Clear button present on the ribbon which is on the right section of the filter button.

This will leave the filter turned on, but it will clear all the filter settings. So now you can make a fresh start with your complete data. If your Filter function button is appearing gray in color then it means that the filter not working in Excel.

The reason behind this can be that your grouped worksheets. While using the Equals filter, Number Filter, or Date Filter, if your Excel is not showing the right data then check whether the format of your data is the same or not.

Suppose, if you are having 2 cells and in each cell, you have entered as data. 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. That did the trick. I found the same as Deborah Arndt i. Your email address will not be published. Notify me of follow-up comments by email.