Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
When you say "the bottom half of the pop-up screen is blank", do you mean there are check boxes without values next to them or do you mean the list ends before it should? –  CharlieRB May 16 '12 at 11:42
    
No values, no check boxes apart from (Select All), nothing underneath it. –  DVP May 16 '12 at 13:02
    
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. –  CharlieRB May 16 '12 at 13:27
    
Aha! I've found what was causing it, and yes you were right it was another filter which i didnt even notice! Appreciate your help CharlieRB!! –  DVP May 16 '12 at 15:47
    
Sure thing. I will add it as an answer. If you would be so kind to choose it I would be grateful. –  CharlieRB May 16 '12 at 17:07

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.