How do i add additional sheet to a workbook made with a template .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add pages to a workbook i made with a template, but when i
insert a sheet, it does not contain the same formatting from the template.
How can I insert a new sheet with the templates design?
 
Tsunami,

Copy the sheet (Ctrl-Drag a sheet tab). Remove any data you don't want from
the copy. Right-click the tab of the new sheet to rename it.
 
You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).

Gord Dibben Excel MVP
 
Back
Top