Autofilter not accepting custom

[Tom]

I was setting up autofilter so that it would display
entries whose values are greater than zero. I made the
changes in the custom window and clicked OK. The filter
didn't work so I went back in to check it and the changes
I made had not taken effect.

I tried a number of things, but what seem to resolve the
issue was to delete any blank columns from the
spreadsheet. Seems a bit strange. Is there a quirk in
Excel where you can't have any blank columns in the
spreadsheet when using autofilter on a non-blank column?

Tom

 

[Frank Kabel]

Hi
you may select first the entire data range before applying an
Autofilter