Excel 2003 Page Break/Print Area Q
February 1, 2011 1:18 PM   Subscribe

Microsoft Excel 2003 Question: Can I manually set the Page Breaks in Page Break Preview, and THEN print the document so that each manually set page will fill the entire printed sheet of paper?

I have yet to figure out how to do this; all the ways I try give me one or the other- I set the Page Breaks, and then print the pages I want and they don't fill the whole paper (which is extra stupid as it makes the text smaller than necessary). I set it up in Page Setup to automatically fill the page, and I lose my page breaks. Please help!
posted by ThePinkSuperhero to Computers & Internet (3 answers total) 3 users marked this as a favorite
 
It depends on your printer. If the max allowable printer margins are limited, you won't be able to print to the edge.

As far as Excel's margins, you can set "Fit" width to one page and the height to 999 pages. That will give you the largest print area.
posted by lampshade at 1:47 PM on February 1, 2011


As far as Excel's margins, you can set "Fit" width to one page and the height to 999 pages. That will give you the largest print area.

Ah ha, I had not thought of that! Setting the "Fit" to a larger number than the actual number of pages I am doing seems to have allowed the pages I am setting to fill the paper. YOU WIN THE PRIZE.
posted by ThePinkSuperhero at 1:56 PM on February 1, 2011


Great!
posted by lampshade at 2:02 PM on February 1, 2011


« Older I have the worst teeth you have probably ever seen...   |   Good neighborhood near BART? Newer »
This thread is closed to new comments.