MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"Margins do not fit page size"

Posted by Lisa on May 18, 2001 9:42 AM

I have a worksheet that has 22 graphs set up to print
on 6 pages. All was printing fine until I got the
bright idea to set it to one print area and put in page
breaks. It worked for a while, then I closed and came
back later. When I opened it back up and tried to print
preview, it now wants to print each cell on a separate
page and I get the error message "margins do not fit
page size". Even when I try to change the print area
to something smaller, it still gives me this problem.
Why is it doing this? How can I fix it?


Posted by Dee on May 18, 2001 9:47 AM

Wherever you put in the page breaks, go back in and select "remove page breaks" the same way you put them in. This should set it back to the way you had it before when it was printing fine.

Posted by shirish on May 27, 2001 8:52 AM

Posted by shirish on May 27, 2001 8:53 AM

Go to page set up
and adjust page width manually