| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to hide blank rows after data whilst leaving some blanks.
I have a worksheet which has data pulled through of various lenghts. I know
how to hide all blank rows so i can reduce the print range, but on this sheet the data is in every third row down. How can I hide blank rows after the last entry, but not hide the blank rows between the data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a column leaving out any blanks | Excel Worksheet Functions | |||
| Hide Blank Rows | Excel Worksheet Functions | |||
| combine speadsheets leaving no blank rows on master page | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Formula to hide blank rows | Excel Worksheet Functions | |||
Linear Mode
