Sunday, December 16, 2012

How to Create a Spreadsheet Template in Excel 2003


1. Open a new Excel document.
2. Make your spreadsheet. Include all the formatting you would like for your template. Add the fonts, cell colors, macros and anything else you would like.
3. Include only the information that needs to be on every spreadsheet. For example, if you are making a template for a budget, add the headings but not the entries for each transaction.
4. Go to File > Save As. Below the box where you name the file, there is a drop-down menu with file types. Save your file as a '.xlt' Template file. Name the file and click Save.
5. Use the template. Go to File > New. This will bring up a few options, including one for the template you made.

Blogger news