MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I delete extra pages of blank rows?


Posted by Chris Poldervaart on October 19, 2000 8:06 AM

Somehow I have a singe page worksheet, but when I print it I get 3 extra blank pages. How do I get rid of these blank pages? Thanks!!


Posted by Loren on October 19, 2000 9:22 AM


Highlight the desired print area, then
File-Print area-Set print area

Posted by Chris Poldervaart on October 19, 2000 12:50 PM

I tried it, but I still have two pages printing when I only want one page. Any other ideas?

Posted by Chris Poldervaart on October 19, 2000 1:01 PM

THANKS LOREN...YOU WERE RIGHT!!!

I goofed, and tried it again like you said, and it worked like a charm. Thanks very much, and I am sorry it took two tries to find out you knew what you were doing all along.