How to Create a Spreadsheet Template in Excel 2003


If you would like to use the same basic setup for several Excel spreadsheets, it might be wise to create a template. Follow these steps to create a spreadsheet template in Excel 2003.

Things You'll Need

  • Computer with Excel 2003
  • Open a new Excel document.

  • 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.

  • 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.

  • 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.

  • Use the template. Go to File > New. This will bring up a few options, including one for the template you made.

Tips & Warnings

  • You cannot add special characters to filenames.
  • Save frequently or you could lose your work.

Related Searches

Promoted By Zergnet


You May Also Like

  • How to Create Excel Templates

    Microsoft Excel allows you to create lists, databases and charts that are effective, comprehensive and functional. Microsoft also offers hundreds of templates...

  • Is There an Excel Template for Check Registers?

    Microsoft Excel offers several built-in templates and many more you can download from the Internet. Checkbook registers are not included in the...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!