Customize Print Setup

[bob]

When you go to File > Print Setup, on the Page tab under scaling, you can
pick Fit to _ page wide by _ tall. Does anyone know how to make this option
a default option? Anytime I select the option, it stays selected until I
close excel but it goes back to Adjust to: anytime I open up a new excel
document.

If it can't be done, it'd be nice knowing, too.

Thanks,
bob

 

[Dave Peterson]

Start a new workbook.
Change that setting (and any other setting you want) for each worksheet in that
workbook.

Save it as a template file (*.xlt) in your XLStart folder. Call it book.xlt

When you click the new icon, excel will use that as the basis for the new
workbook. That new workbook will inherit all the settings in the template
workbook.

You can create another workbook named sheet.xlt and store it in that same
XLStart folder and any new sheet added to an existing workbook will inherit the
settings from sheet.xlt.