Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Just what the title states; the sheet in the work-book is not protected. It is possible to select a column, and then click upon the 'filter'. The expected result on performing this action is to see a combo in the first row listing all entries in each row of that sheet.

This fails silently; there is no warning/error, and yet the filter combo-box fails to appear on the first row for any column in this sheet.

Why would the filter combo-box fail to appear ?

EDIT: Follow-up detail that I failed to spot earlier. The first row simply is not visible; row count that appears to the left of the spread-sheet begins at '2' instead of '1'. I take this to mean the filter comboy probably remains invisible because that entire row is hidden. How do I make the first row visible?

share|improve this question
What version? Are there any spaces between the headers and the data? – datatoo May 4 '12 at 14:37
2007. No spaces. It's a biggie though, 16MB almost – Everyone May 4 '12 at 17:46

Not sure this is an answer, but not sure how else to test it.

Is it possible that someone has included a macro that is hiding autofilter indicators? Turn off the filter and run this

Sub ShowDropdowns()
 Range("A1").AutoFilter Field:=1, VisibleDropdown:=True
End Sub

If you still see nothing, then I don't know.

I at one time had a huge sheet that would never turn them off, which was the opposite problem, and it was related to corruption in the sheet and how it was constructed.

share|improve this answer
I'll check it out (+: Thanks! – Everyone May 5 '12 at 9:17

Your Answer


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.