Excel uses top cell as a title.

Add a title to the column so 0 is not top cell.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 09:59:06 -0700, Betsy
wrote:

I have a worksheet with several columns. I am trying to filter column E and
column J. When I select the column and go to "Data, filter, auto filter, I
get the grey arrow at the top of the column. When I filter the column to
only show the number 1, it works, however it won't filter the very first cell
of the column. So if there is a zero in that first cell, it remains, even
though all other zero's are removed after the filter is added.

Why isn't it filtering the very first cell of the column?