Excel Column Widths When Printing
 

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?

Excel Column Widths When Printing
 

Even if you have selected 'Fit to 1 page wide' from print preview Page
SetupUnder 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
---------------
Jacob Skaria


"Joe G" wrote:

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?