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
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