Interesting, but I don't see how it tells me how to switch from template to
template on the same sheet. For instance, sometimes I only want to work
with columns A, D, F and G. Other times I want to work with columns A,B,C.
Sometimes I want the rows quite high. Other times not. But always working
with the same set of data. Am I not seeing something?

"Ron de Bruin" wrote in message
...
For the OP, see also
http://www.rondebruin.nl/sheettemplate.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Laurel

It will work the same as in XL2003.
Create the sheet you want as mentioned previously, starting from a new
workbook with a single sheet.
Round Office ButtonSave AsExcel WorkbookSave as TypeExcel
Templategive it a NameOK
Close the file just created

To use, in any new workbook, right click on Sheet tabInsertselect your
templaterename sheet to whatever you want.

Do note that if you have an old xls file that you have loaded in
Compatability mode in XL2007, you will not be able to insert your 2007
excel template sheet. You would need to have created one in XL2003 and
have available in your Templates folder.
--
Regards
Roger Govier

"Laurel" wrote in message
...
Thanks. I'm using Office 2007, so I had to go to HELP to figure out how
to create and use a template instead of following your script. But this
didn't tell me how to use a template on an existing workbook. In other
words, it seems like it's only good for starting a new workbook. The
HELP I used is below. Any ideas?


Create and use an Excel template
Show All
Hide All
To save time or to promote standardization, you can save a workbook as a
template (template: A workbook that you create and use as the basis for
other similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.) that you can use
to create other workbooks. In Microsoft Office Excel 2007, a template
file (.xltx) can include data and formatting, and a macro-enabled
template file (.xltm) can also include macros (macro: An action or a set
of actions that you can use to automate tasks. Macros are recorded in
the Visual Basic for Applications programming language.).

You can use one of your own templates to create a new workbook, or you
can use one of the many predefined templates that you can download from
Microsoft Office Online.

What do you want to do?

--------------------------------------------------------------------------------

a.. Create a template
a.. Use a template to create a new workbook

--------------------------------------------------------------------------------

Create a template
1.. Open the workbook that you want to use as a template.
2.. Click the Microsoft Office Button , and then click Save As.
3.. In the File name box, type the name that you want to use for the
template.
4.. In the Save as type box, click Excel Template, or click Excel
Macro-Enabled Template if the workbook contains macros that you want to
make available in the template.
5.. Click Save.
The template is automatically placed in the Templates folder to ensure
that it will be available when you want to use it to create a new
workbook.

Tip You can copy any Excel workbook into the Templates folder, then
you can use the workbook as a template without saving it in the template
file format (.xltx or .xltm). In Windows Vista, the Templates folder is
usually C:\Users\<your name\AppData\Roaming\Microsoft\Templates. In
Microsoft Windows XP, the Templates folder is usually C:\Documents and
Settings\<your name\Application Data\Microsoft\Templates.


Top of Page


Use a template to create a new workbook
1.. Click the Microsoft Office Button , and then click New.
2.. Under Templates, do one of the following:
a.. To base the workbook on a recently used template, click Blank and
recent, and then under Recently Used Templates, double-click the
template that you want to use.
b.. To base the workbook on an installed template, click Installed
Templates, and then under Installed Templates, double-click the template
that you want to use.
c.. To base the workbook on a template that you created, click My
templates, and then on the My Templates tab, double-click the template
that you want to use.
d.. To base the workbook on another workbook, click New from
Existing, and then double-click the workbook that you want to use.
Tip When you are connected to the Internet, you can also access
templates that are available from Office Online. Under Microsoft Office
Online, click a template category, and then under that category,
double-click the template that you want to download. If the template
that you want to download has been supplied by a member of the Microsoft
Office Online Community, you must click I accept to accept the License
Agreement for Community Templates Terms of Use before you can download
that template.


Top of Page

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Laurel

I would open a new workbook and delete all except for Sheet1
I would create the sheet as I wanted it, with all the various columns,
row
heights etc., but with no data and save this as a Template
with FileSave asTemplatesMySheet

Then when required, InsertSheetMySheet

--
Regards
Roger Govier

"Laurel" wrote in message
...
... and row heights and orders of columns, so I can call them up at a
later time?