Why does my worksheet print on more pages when scaled down to 10%?

W

what the heck!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top