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!
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!
Response by poster: 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
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
« Older I have the worst teeth you have probably ever seen... | Good neighborhood near BART? Newer »
This thread is closed to new comments.
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