I love your videos. Everything is so precise and to the point.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2010

Single page view print copy

Using Templates

Using templates

Video: Using Templates in Excel 2010

Launch video!Watch the video (1:56).

Excel allows you to create a new workbook using a template, which is a pre-designed spreadsheet. Several templates are pre-loaded in Excel, and others are located on Office.com.

To create a new workbook using a template:

  1. Click the File tab to go to Backstage view.
  2. Select New. The Available Templates pane appears.
  3. Click Sample templates to choose a built-in template, or select an Office.com template category to download a template. In this example, we will download a template from Office.com.
    Available Templates paneAvailable Templates pane
  4. Thumbnail images of the templates you have to choose from appear in the center. A larger preview appears on the right.
  5. Select the desired template, then click Download to open it. (If using a Sample template, Download will be replaced by Create.)
    Opening a templateOpening a template
  6. A new workbook will appear using the template you chose.
    New workbook utilizing a templateNew workbook utilizing a template

Use caution when downloading Office.com templates. Some of them are uploaded by people not affiliated with Microsoft, and Microsoft cannot guarantee that those templates are free from viruses or defects. For those templates, you'll see a warning message before downloading them.

Warning message for a non-Microsoft templateWarning message for a non-Microsoft template
1 2 3