How do I create an Excel Template?
 

I am trying to set up an Excel Template to use for my personal budget and
expenses. I know how to simply use Excel by going in and widening columns
etc. but it seems to make more sense to create a template I can use each year
or each quarter and it looks like a "report" instead of a group of bunched up
numbers.

Can anybody help?

How do I create an Excel Template?
 

Set up a workbook with the formatting and whatever else you wish.

FileSave AsFile TypeExcel Template(*.xlt)

Type a name for it but don't add the extension, Excel will look after that.

Store it in your Templates folder.

The MS Template Gallery has some nice Budget Templates for download to save you
all the work of building your own.

http://office.microsoft.com/en-us/te...172321033.aspx


Gord Dibben MS Excel MVP

On Thu, 21 Dec 2006 15:18:01 -0800, AnneLee
wrote:

I am trying to set up an Excel Template to use for my personal budget and
expenses. I know how to simply use Excel by going in and widening columns
etc. but it seems to make more sense to create a template I can use each year
or each quarter and it looks like a "report" instead of a group of bunched up
numbers.

Can anybody help?