Margins do not fit page size ERROR

J

jbrunsdale

New Member
Joined
Jan 14, 2009
Messages
11
This happens sporadically. When I have summarized data all by itself or I might have data in say Columns Q thru Z and summarized data in columns A thru J, when I go to set the print area, I get a nasty message:

Margins do not fit page size

And suddenly, every single cell becomes a printable page. I can't seem to be able to set up a proper page size without either having dimensions which don't fit my report or having each cell representing a whole page. Additionally, although this happens only once in awhile, once it happens to a certain sheet or report, it comes up again - even when I copy all the data onto a new page.

Please help!!! Thank you.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
I always find printing in excel to a be a pain.

My only suggestion is to change the view to 'Page Break Preview' and you can then move around the print areas. Might help?


speedball
 
Upvote 0
Thanks for the clarification.

When I go into "Page Break Preview", that's where the problem occurs. I'll move a column or row line to the right or down (respectively) and that's when I'll suddenly get the Margins do not fit... error box, I click "Ok", and suddenly hundreds of page breaks encompass every cell. And it's every cell, not random, but every cell.

Other people in my office have experienced this problem.
 
Upvote 0
Something else that you could try is to amend the Scaling and Margin settings in the Page Setup (File/PageSetup)?
 
Upvote 0
True, I can solve the "Margins do not fit" error by going into Page Setup, but then I can't go back and make any page area modifications. Only if I delete the "Print Area" specifications can I remove the error. In that case, the print area doesn't cover what I need to print - it's better, b/c I can at least print something recognizable. But, I'm unable to put everything I want to print on the appropriate number of pages.

Thanks for your help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
PDF - Page Size Issue
Replies
2
Views
483
kgallego
K
D
  • Question
VBA Control Of Page Breaks
Replies
2
Views
878
DannyDont
D
M
  • Solved
Fit Columns to page in printer settings isn't working right
Replies
2
Views
444
Mr_Phil
M
X
  • Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
254
KRice
K
A
  • Question
How can I get my print to PDF button print to normal page without selected printer?
Replies
1
Views
1K
DacEasy
DacEasy

Forum statistics

Threads
1,214,651
Messages
6,120,742
Members
448,989
Latest member
mariah3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top