Blank pages

C

Connie

My worksheet has 47 pages, but only data on 9 pages. In
print preview it's showing hundreds of empty rows. I have
deleted them, saved, closed the file, but they are still
there. How do I get this crazy thing to print down to the
last row where there is data, and no further? I don't
want to set the print area because then I have to reset it
everytime I add more rows of data.

Thank you
Connie
Mississauga, Canada
 
D

Don Guillett

If you didn't delete the rows using the row number on the left, try that. Be
sure and save. I have heard that one some versions you had to leave quit
Excel and come back.
 
Top