Exel Auto Filter

Dave · External Since: Mar 14, 2006 Posts: 358

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 · External Since: Sep 26, 2003 Posts: 1966

Select all data first Dave before you turn on AutoFilter

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave" <Dave DeleteThis @discussions.microsoft.com> wrote in message news:76232524-DDB8-4BDF-A9C0-0FFA094F66BB@microsoft.com...
>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
>