have you tried the 'Scale To Fit' function on Page Setup? Here you can
set the entire worksheet, or the desired print area (i.e. those cells
required for the worksheets contents ) to fit 1, 2, or more pages width
and/or height.

Go to: 'File' 'Page Setup' 'Page' 'Scaling'

hope this helps!