ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does my worksheet print on more pages when scaled down to 10%? (https://www.excelbanter.com/excel-discussion-misc-queries/178742-why-does-my-worksheet-print-more-pages-when-scaled-down-10%25.html)

what the heck!

Why does my worksheet print on more pages when scaled down to 10%?
 
I'm working with a workbook that when I grouped all of the pages and printed
the entire workbook printed on 17 pages. When I ungrouped the workbook with
the page break preview on, one worksheet that was only 2 pages on the initial
print (which was somewhere around 70% scaled) is now 44 pages! The worksheet
is only 6 pages when I set the scale to 100%. When I go to reduce the
scaling, it will not fit to 1 page wide any longer (says to do so would
violate the Excel rule limiting scaling to values below 10%). I've gone to
the page break preview and attempt to drag the right limit of the page over,
it scales the worksheet to print on 44 pages (supposedly at 10%)!

I'd really like to get my workbook back to printing on 1 page wide (legal).


All times are GMT +1. The time now is 07:09 AM.

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