Printing out extra blank pages in worksheet

Posted by Mike on February 10, 2002 4:56 AM

After adding rows & columns in a workbook, I check print preview and it says 64 pages when the actual amount of pages should be 6. How did I get the extra pages and how do you keep from doing it again?
Thanks

Posted by DK on February 10, 2002 4:59 AM

Select the entire area you want to print and choose File, Set Print Area.

Posted by Yogi Anand on February 10, 2002 1:11 PM

Hi Mike:
First follow DK's suggestion -- if you get the printout on right number of pages, you are all set; otherwise for further look into how Excel is formatting the pages, go to VIEW|PageBreakPreview ... you will able to see the page breaks laid out.
HTH

Yogi Anand
ANAND Enterprises (broken link)