Excel Autofilter NOT WORKING

[ste4en]

I received a spreadsheet which has about 700 rows. When I turn on the autofilter on the top row it does not give me the list of values; actually it just gives me the first value in the row beneath the header row where the autofilter is set.

There are no blank rows. Why does this filter not work, any ideas. Thanks

Steve

 

[xlhelp]

You probably have hidden blank rows. Highlight the whole spreadhseet, go Format, Row, Unhide.

Member- AAAA Association Against Acronym Abusers

 

[ste4en]

Thanks but no hidden rows...

 

[BlueHorizon]

Hi,
Do you have Freeze Panes on? Sometimes this distorts what you see in the dropdown box.



Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[ste4en]

Freeze panels were not on.

I eventually made some new data on a new sheet in the workbook and the filter worked. I copied the whole sheet to the new sheet and the filter dod not work.

I copied the data without header row added my own header and it worked. I then copied the header from the bad sheet and everything worked as it should.

So I have no idea what happened or why, but it is fixed.

thanks

Steve