Change Default Printer Settings

[gneissgirl]

Hello, how can I change Excel's printer settings so that every time I open a new workbook, the settings to print are always set to Landscape and the scaling is always set to Fit All Columns on One Page? I'm using Excel 2010. Please help, thanks.

 

[ranman256]

the excel sheet controls the printer settings.

record a macro,in PERSONAL workbook ( so its available in all workbooks)
set the printer settings,
stop recording

now you can run this to set the printer in any workbook.