I 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.)

JohnJ wrote:

My standard practice is to set up a footer with "&[file]" in the left custom
footer box, "Page &[Page]/&[Pages]" in the center box and "&[Date]" in the
right box. I would like to save this in the drop down menu but have not been
able to find out how to do this. There are other footers there and I have no
idea where they came from. Any help? Thanks.

--

Dave Peterson