O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Template Files to Store Formatting

A template file 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 time-savers. They're also an ideal way to ensure a consistent look among reports, invoices, and other documents you tend to create repeatedly. Figure 9-7 shows an example of a template for an expense report. This worksheet would work well as a template because expense reports are used repeatedly, but each time you'll want to start with a fresh, clean copy.

This template file serves as the basis for creating new expense reports.

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

Note

You can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required