Blank pages

  • Thread starter Thread starter Connie
  • Start date Start date
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
 
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.
 
Thank you, Frank. You keep answering my questions!

Connie
Mississauga, Canada
 
You must log in or register to reply here.

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

Arggh! Each row prints on separate page 2
Excel VBA - Problem with Closing Print Preview 0
how can i print (row) titles on all pages except the last page? 3
Blank Sheet with Gridlines 11
Printing multiple sheets... 1
Prints only part of specificed print area 1
Selecting Pages to Print 1
not printing grouped columns 2

Back
Top