how to have excel repeat a template on each page of each workshee.

[Guest]

i have created a template that i want to have on each page of each worksheet.
is there command to make this happen/

 

[Debra Dalgleish]

You can create a new default template, with your preferred settings:

Open a new workbook.
Copy your template onto each worksheet
Choose Save As
From the Save As Type dropdown, choose Template (*.xlt)
Name the File "Book.xlt"
Save it in the XLStart folder
(usually in Program Files/Microsoft Office/Office)

When you click the New button on the toolbar, the new workbook will be
based on this template.

If you want new sheets to be inserted with the same settings, you can
create a sheet template.

Follow the steps for creating a workbook template, but:
-- create a workbook with only one sheet
-- save as Sheet.xlt