Printing question regarding scaling

[DukeRollo]

Good afternoon.

Is there a way to set Excel to default to print 1 page wide by 1 page tall?

I work for a company that does quite a bit by paper. We also have multiple spreadsheets.

Most of what we print is all over the place on the page and each time I open a new spreadsheet, I go to PAGE LAYOUT then bring up the Page Setup tab in the Scale to Fit section and manually select "Fit To: 1 page(s) wide by 1 tall".

Having to do this for each tab of each of the many many spreadsheets I open is tedious. It would be way better if all the spreadsheets I opened would default to the 1 by 1 setting. Is there a way to set that up without doing it tab by tab?

Thank you for taking the time to read. As always, your suggestions and answers are greatly appreciated.

[tim201110]

you can create a tempate whatever you want and use it new spreadsheet

[Alf]

Perhaps a macro that loops through all sheets?

Please Login or Register  to view this content.

Alf