Save As a Template

2. What is the File Name?

Type: Sales Template


3. What is the File Type?

By default, the file type for Excel 2007 and 2010 is Excel Workbook. A template is a different File Type. You need to choose Excel Template from the extensive list of file types that Microsoft Office supports.


An Excel Template is an *.xltx file type.


4. Where are you saving it? When you choose Save as Type: Excel Template, then Excel will switch to the default location for Templates.


Click on Save, please. Keep going...

File ->Save As-> Excel Template

Exam 77-882: Microsoft Excel 2010 Core

7. Sharing worksheet data with other users

7.1. Share spreadsheets by using Backstage: Change File Type