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

Top