ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I adjust print scaling for multiple print areas on the same sh (https://www.excelbanter.com/excel-discussion-misc-queries/191781-can-i-adjust-print-scaling-multiple-print-areas-same-sh.html)

N. Sammons

Can I adjust print scaling for multiple print areas on the same sh
 
If I have one large print area on a sheet (say 50 X 50 cells ) and one small
print area (say 10 X 10) on the same sheet at the same time, when I go print
by fitting to 2 pages Excel sets the print scaling so that the 50X50 area
will fit on one page, and then applies that same scaling to the 10X10 area
(so that the second page/print area comes out unecessarily small). Is there
a way to tell excel that I want it fit the two areas to two pages, but scale
each page individually?


All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com