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.
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.
gotta be a better way, maybe someone has a good idea. Thanks in advance for any help.