Excel Column Widths When Printing

[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?

 

[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