Page Setup questions...

  • Thread starter Thread starter Chris Marsh
  • Start date Start date
C

Chris Marsh

Is there a way to setup Excel so that it remembers my default desired page
sizes? For example, the margins are .75 L/R and 1.0 T/B with headers and
footers. How can I change these defaults and get them to stick?

Thanks,

Chris
 
I'd set up two template workbooks with what I want each page layout to be.

The first one is named book.xlt (file|saveas|Template (*.xlt)).

This is stored in my XLStart folder. When I click the New icon on the standard
toolbar, I get a new workbook based on this template.

The second one is named sheet.xlt and is saved in the same location (XLStart
folder).

When I add a new worksheet to an existing workbook, I get a worksheet based on
this template.

(I really created a single sheet workbook and saved it as book.xlt, then I just
copied that book.xlt to sheet.xlt--all within my XLStart folder.)
 
Thanks Dave - I will give this approach a try!

Dave Peterson said:
I'd set up two template workbooks with what I want each page layout to be.

The first one is named book.xlt (file|saveas|Template (*.xlt)).

This is stored in my XLStart folder. When I click the New icon on the
standard
toolbar, I get a new workbook based on this template.

The second one is named sheet.xlt and is saved in the same location
(XLStart
folder).

When I add a new worksheet to an existing workbook, I get a worksheet
based on
this template.

(I really created a single sheet workbook and saved it as book.xlt, then I
just
copied that book.xlt to sheet.xlt--all within my XLStart folder.)
Click to expand...
 
Back
Top