Page Scaling & Print Titles Issue

jdutle

New Member
Joined
Dec 8, 2015
Messages
17
Hello. I am having trouble figuring out the relationship between page scaling and the inclusion of print titles. Please see the attached image for reference. Thank you in advance for your help.

Basic Question: If I have a sheet scaled to fit on one page and no print titles are included it scales to X, but if print titles are included then it scales to Y.

I have a template with multiple tabs I use to illustrate different products/options for a client. Each Tab contains options for different types of products. The number of options can vary, but the goal is usually to have them illustrated and scaled to fit one page. About half the time there are so many options included that I need to break the sheet to print on two pages, otherwise it would scale too small to be legible. I'd like the Print Titles to already be set up just in case I do need to split the page. Usually, the Print titles consist of the Info and Current columns.

Adjusting the scaling and print titles for one tab is pretty fast, but the example attached is just part of a much larger template, where the same requirements are needed on each tab. There can be 40+ tabs at times, and I'd like to get the template set up, so I need to adjust as little as possible.

Please see the example attached. Both tabs are identical and are scaled to fit on one page. The only difference is the first page includes print titles and scales to 54%, and the second tab does not include print titles and scales to 71%.

Cross Posted at
ExcelForum
Chandoo

picture.png
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

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