Auto Hide Blank Rows

  • Thread starter Thread starter Brandon
  • Start date Start date
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
 
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

auto hide blank rows 1
Hide rows function 4
hide row on spreadsheet 3
Write a macro that hides rows based on empty cells 3
Macro - hide rows that are 0 without an auto-filter 3
Sort Ascending Using Auto-Filter Ignores First Row 1
Hide rows when specified columns equal zero 1
auto hide 8

Back
Top