Auto Hide Blank Rows

B

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide rows function 4
Macro - hide rows that are 0 without an auto-filter 3
auto hide blank rows 1
Hide rows when specified columns equal zero 1
Deleting blank rows 4
Deleting blank rows with formulas in them 7
Insert blank rows 2
auto hiding blank rows and columns 5

Top