Autofilter header row

M

Mister Cul-de-sac

My experience has been that the first row is where the controls (down arrow)
appear when autofilter is invoked. But I've now been sent a spreadsheet (just
unformatted data in a large table) where the autofilter chooses the second
row. I've compared the new spreadsheet with previous versions and don't see
any difference in layout, etc.

What can be causing this problem? Is there something "invisible" that tells
Excel which is the header row for the data to be filtered?

If I select row 1 and then click autofilter, the controls do appear on row 1
but otherwise it's always row 2 in this spreadsheet.
 
G

Gary''s Student

I have seen this problem if a column (usually on the right) does not have
data in the header cell.

Make sure every column has a non-empty header cell!
 
M

Mister Cul-de-sac

Thanks, upon closer inspection I found that was exactly what had happened.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top