Excel Column Widths When Printing

J

Joe G

I have multiple ranges on the same page that I would like to print so that
they look uniform when printed, however I'm noticing that there must be some
amount of space excel allocates between columns when printing.

I have one range that is 27 columns wide, but the sum of the column widths
is 120.
I have another range that is 13 columns wide, with the sum of the column
widths at 120.

Both ranges are set to auto fit to 1 page wide and auto pages long...

The range that is 27 columns wide always prints out in a smaller font than
the one that is 13 columns wide.

Any suggestions?
 
J

Jacob Skaria

Even if you have selected 'Fit to 1 page wide' from print preview >Page
Setup>Under Scaling> notice the difference 'Adjust to ' % which auto adjusts
to accomodate these print area one page wide....The % difference is reflected
as the font size difference.

If this post helps click Yes
 

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