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

T

thomsonpa

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?
 

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

Copying Portions of Data 0
Publisher is filling blank lines with data 2
Zero problem with blank cell after automated data transfer 3
fifty thousand rows 5
Shifting rows to sheet2 using Macro 5
How to protect & hide Sheet 3
how to delete some rows without data which comes in between rows with data 4
Hide rows in table based on 1 empty cel of the same row. 1

Top