Hi Robert

When you select the whole data column and there are blanks
you see "Blanks" in the filter list when you click on the arrow in the header

--

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


"robert mills" wrote in message ...
how do i find nonblank filters in excel when working with spreadsheets