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" <JohnSullivan@discussions.microsoft.com> wrote in
message
news:C8C1A892-F2E6-4DED-B3D8-A6496B26A8A0@microsoft.com...
> 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.
Bookmarks