Exel Auto Filter

[Guest]

I want to use auto filter on columns, but I have cells that are blank and
when I use the drop down on the auto filter, its doesnt pick up anything
after the blank cells. Is there a way around this, as I do need to have blank
cells in my columns.

Thanks

 

[Ron de Bruin]

Select all data first Dave before you turn on AutoFilter