Did you try selecting NonBlanks from the auto filter options?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"lehigh46" wrote:

Hi All,

I have a grid which has letters across the top.
I also have numbers down the left side.
In some cases I have an "X" in the intersection of the numbers &
letters & in some cases I don't.

I can collapse the rows with Auto Filter if I don't have an "X", but
is there a way to collapse the columns to eliminate blanks?

Thanks for your help.

Tom