Menu
Click on Fit under the Scaling in the Page tab in the dialog box. You have to choose 1 in both the boxes that are next to the Fit to option. Excel will shrink all the data into one page, and you will click on the OK button to save the setting.
The only thing I would want is to always set the 'Fit all columns on one page' setting when users open the Print tab in Excel.
And no, they don't want to do it themselves. What a surprise :)
Here is a screenshot of where that is in Excel 2013:
Tried to look for some VBA code like the following but without success.
With Sheets("Print Letter").PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With