Insert a formatted worksheet into a workbook

**Cled** · 08-12-2009, 04:54 AM

Using Excel 2003 under Windows XP Professional.

I would like to format a worksheet that I can then insert into an existing workbook as needed, and I would prefer a one-step process.

I know that I can right click on a worksheet tab and insert a template, but when I choose "save as a template", an entire workbook is saved. I guess that if I could save a one sheet only template it would solve my problem.

How should I do this?

Thank you very much.

**martindwilson** · 08-12-2009, 05:13 PM

jusy copy /paste?

**Cled** · 08-12-2009, 08:21 PM

Thank you for replying.

Copy/paste?

That is an awful lot of steps:
Open the template sheet, which is in another workbook
Copy it
Go back to the workbook that needs the sheet
Paste special

Is there seriously no way to save a sheet template and then insert it from the context menu?