Browse » Home
Thursday, July 25, 2013
How to Create a Template in Excel 2007
1. Open Microsoft Excel 2007 on the computer.
2. Click the 'Microsoft Office' button from the main program menu, and then click 'Open.' Browse to and double-click the existing Excel workbook or worksheet that you want to use as a template. If you don't have an existing spreadsheet, click 'New' to create a new Excel document to use as a template.
3. Enter the information and add the elements that you want to include in the Excel template. This should include all the data, graphics, text, macros and formulas that the template requires to work properly.
4. Click the 'Microsoft Office' button on the main menu, and then click 'Save As.'
5. Type a name for the template in the 'File Name' box.
6. Click 'Excel Template' in the 'Save As Type' box. If the workbook contains macros that you need to include in the template, click 'Excel Macro-Enabled Template' in the 'Save As Type' box. Click 'Save.'