Menu
The Basic Excel Filter (Excel AutoFilter) - Description of Use, with Examples. If your Excel Autofilter works for the top part of the data in your spreadsheet, but.
I have an Excel Table (created by CTRL+T), where filter buttons are added by default. But suddenly they disappeared and the checkbox for switching them on/off is greyed out.
There are two other tables in same sheet and they work properly. I can't figure what causes this behavior.
Sceenshot:
Copying sheet to another/new workbook doesn't help. How can I stop this from happening?
LluserLluser
2 Answers
I had the same issue. When I turned 'header row' off and on again they reappeared. (Yes I am congnizant of the fact that it sounds like a fix to every other MS apps issue... but it actually worked for me.)
ChristineChristine
Select all of the headers, go to Home>Sort & filter> and make sure the filter button is selected in this option. That should fix it for you
Jamie BartlettJamie Bartlett
Not the answer you're looking for? Browse other questions tagged microsoft-excel or ask your own question.
I have an odd problem on a tracker spreadsheet I use. All the columns have a filter, but when you click on the filter arrow it doesn't show you a breakdown of all the text values for that column. All it shows is the usual 'sort A to Z/Z to A', but the bottom half of the pop-up screen is blank, where normally you have a list of text values that you can further filter by putting a tick next to each.
It only displays (Select All) which you can tick, but its pointless as the column has selected all text values and hasn't been further filtered, which is what I need to do.
Journeyman Geek♦
DVPDVP
2 Answers
Just saw this happen yesterday to a friend. Sometimes this can be caused by another filter on another column that is filtering out what you are looking for. Check the other filters. Hope it's that simple.
CharlieRBCharlieRB
For some unknown reason the filter must have been applied to only one row. Since top row values are considered as headers, there are no other values to be displayed.
The solution is to select the whole table and press Ctrl + Shift + L.
Prithvi MPrithvi M