Auto Hide Blank Rows

[Brandon]

I am looking for a forumla that will allow me to hide Rows that do not
contain data. I have a spreadsheet that is bringing information over from
another spreadsheet and some of the fields are blank. This causes gaps in
the data that I would like to have removed. I am trying to have this set up
to automatically hide rows based on if information is coming across from the
other sheet. I am not looking to do this with the Data Auto Filter function.

Thanks
Brandon

 

[Gord Dibben]

Formulas cannot hide rows, only return data.

If the entire rows will be blank, select any column and F5>Special>Blanks>OK

Format>Rows>Hide.


Gord Dibben MS Excel MVP