Printing Frustrations - "Fit To" & Page Breaks

Fujirich

Active Member
Joined
May 1, 2003
Messages
320
I do a lot of forms and contracts for my organization, and many times these will run more than one page. My problem is ensuring that they will print properly, with page breaks falling where they should, not knowing what type of printers my many users may be trying to output these on.

I've found that using the "Fit To" command in Page Setup - Scaling will work perfectly for a one page document, setting the output percentage as necessary for different conditions. But for multiple pages, let's say setting it for 1 page wide by 3 pages tall, I can no longer ensure where the page break will fall. I'm hoping there's something I'm missing that might fix this, because after all these years of development, I can't believe Excel doesn't handle this better.

Let's say I have that 1 page wide by 3 pages tall example. My normal routine would be to set the print area first, then go to Page Setup and set the 1 pages wide by 3 pages tall, then change the View to Page Break Preview. If I adjust any page break in that mode, and then go back to the Page Setup commands, the setting in the Scaling section have reverted to a fixed percentage. It seems that Excel will not scale for different printer characteristics and allow variable page breaks at the same time. Scaling and page breaks are linked.

Is this right? Is there no option? It seems awful limiting if this is the case.

One solution might be to set up a macro that defines each page and prints it separately. But I run the risk of having different percentage outputs if I do that, and if someone wants to print to a PDF it creates multiple files instead of a single one with multiple pages.

There's gotta be a better way, maybe someone has a good idea. Thanks in advance for any help.


Rich
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Try setting only the "Fit to X pages wide" and leave the Pages Tall blank.

Then you can goto page break preview and insert any custom page breaks and it wont change away from the number of pages wide. It will only reset if you specify both dimensions.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,916
Members
448,533
Latest member
thietbibeboiwasaco

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