Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to have excel repeat a template on each page of each workshee.
i have created a template that i want to have on each page of each worksheet.
is there command to make this happen/ |
#2
|
|||
|
|||
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 joanlaw wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is the Template Wizard with Data Tracking Excel 2003? | Excel Discussion (Misc queries) | |||
Hidden page bracks in Excel should be deactivated | Excel Discussion (Misc queries) | |||
insert multiple page Word document into Excel | Excel Discussion (Misc queries) | |||
Does the add in Template Wizard exist for Excel 2003 | Excel Discussion (Misc queries) | |||
balance sheet template in excel adding lines | Excel Discussion (Misc queries) |