Do you mean that you want to hide rows or columns? - it's a bit
confusing in your post.

If you want to hide rows where cells are empty, then you could apply
autofilter to a number of columns and select "non-blanks" from the
filter pull-downs.

Hope this helps.

Pete


On Feb 6, 3:14*pm, LiveUser
wrote:
I did a search on here and wasn't confident that some of the responses
answered my question.

I have a about 400 rows of information. A lot of the row information is
blank except for the first two columns A and B. Is there a way I can collapse
all the "blank rows", which are the rows that don't have data after column A
and B?

Thank you.