Microsoft® Excel® 2010 Inside Out

Using Template Files to Store Formatting

A template is a model that can serve as the basis for new worksheets. A template can include both data and formatting information. Template files are great timesavers. They’re also an ideal way to ensure a consistent look among reports, invoices, and other documents you tend to create repeatedly. Figure 9-64 shows an example of a template for an expense report. This worksheet would make a good template because expense reports are used repeatedly, but each time you want to start with a fresh, clean copy.

Figure 9-64. This template file serves as the basis for creating new expense reports.

Note

You’ll find the ...