View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
thomsonpa thomsonpa is offline
external usenet poster
 
Posts: 31
Default 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?