Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Hide Blank Rows
Formulas cannot hide rows, only return data.
If the entire rows will be blank, select any column and F5SpecialBlanksOK FormatRowsHide. Gord Dibben MS Excel MVP On Wed, 25 Feb 2009 11:44:07 -0800, Brandon wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to hide blank rows | Excel Worksheet Functions | |||
Hide rows of cells that are blank | Excel Discussion (Misc queries) | |||
Hide Blank Rows | Excel Worksheet Functions | |||
Formula to hide blank rows | Excel Worksheet Functions | |||
remove or hide blank rows | Excel Discussion (Misc queries) |