Using Templates Excel 2010

Introduction

Lesson 16
In Excel 2010, there are many templates that can save you a lot of time. A template is a predesigned spreadsheet you can use to create new spreadsheets with the same formatting and predefined formulas. With templates, you don't need to know how to do the math, or even how to write formulas—these are already integrated into the spreadsheet.
In this lesson, you'll learn how to create a new workbook with a template, as well as basic information on how templates work in Excel 2010.

Using templates

Video: Using Templates in Excel 2010

Launch video!
Excel allows you to create a new workbook using a template, which is a predesigned spreadsheet. Several templates are preloaded in Excel, while 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'll download a template from Office.com.
    Available Templates pane
  4. Thumbnail images of the templates you can 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 with Create.)
    Opening a template
  6. A new workbook will appear using the template you chose.
    New 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 these templates are free from viruses or defects. For these templates, you'll see a warning message before downloading them.
Warning message for a non-Microsoft template

Related : Using Templates Excel 2010

  • What are Reference Styles? Excel 2010 What are reference styles? Every Excel spreadsheet contains rows and columns. Most of the time, columns are identified by letters (A, B, C), while rows are identif ...
  • Outlining Data Excel 2010 Introduction If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data ...
  • Merging Copies of a Shared Workbook Excel 2010 Merging copies of a shared workbook Turning on the Track Changes feature automatically shares your workbook. When multiple users collaborate on the same shared wo ...
  • Saving Excel 2010 Introduction Are you saving a workbook for the first time? Saving it as another name? Sharing it with someone who doesn't have Excel 2010? There are many ways ...
  • Working with Charts Excel 2010   Introduction A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and ...