How do you set up a page template so that when I go to print a worksheet, I
don't have to reset the orientation as landscape, reset margins, and the
like? I have a workbook, and everytime I add a worksheet, I now copy another
worksheet and paste it on the new worksheet, but all of the page set up
formatting is at default on the new page.

Create a workbook template named Sheet.xlt with a single
worksheet. Set up your printing preferences on this worksheet and
save the file in your XLStart directory (typically C:\Program
Files\Microsoft Office\Office\XLStart).

Excel will use this as a template when creating new worksheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"John Sullivan" wrote in
message
...
How do you set up a page template so that when I go to print a
worksheet, I
don't have to reset the orientation as landscape, reset
margins, and the
like? I have a workbook, and everytime I add a worksheet, I now
copy another
worksheet and paste it on the new worksheet, but all of the
page set up
formatting is at default on the new page.