Excel 2010 filter arrow not showing text values

Posted by DVP on Super User See other posts from Super User or by DVP
Published on 2012-05-16T11:27:22Z Indexed on 2014/08/24 4:24 UTC
Read the original article Hit count: 422

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.

© Super User or respective owner

Related posts about microsoft-excel-2010

Related posts about dropdownlist