ExcelBanter - How to hide blank rows after data whilst leaving some blanks.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to hide blank rows after data whilst leaving some blanks. (https://www.excelbanter.com/new-users-excel/172537-how-hide-blank-rows-after-data-whilst-leaving-some-blanks.html)

thomsonpa

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?

All times are GMT +1. The time now is 04:18 AM.