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


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?
 
Ad

Advertisements

E

Earl Kiosterud

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.
 
Ad

Advertisements

G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert sheet template loses page setup (2010) 2
Insert Sheet Template Image broken (2010) 1
add personal template to the insert worksheet dialog box 2
Excel Templates in Excel 2007 4
Template formatting disappears 1
Is there a template option for Workbooks.Add(xlWBATWorksheet)? 6
excel template seem not to apply to new sheets 1
Excel Excel macro to insert template sheet to all files in directory 0

Top