• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

III. Organizing Worksheets > 15. Templates

Chapter 15. Templates

Spreadsheets are rarely one-of-a-kind creations. After you’ve built the perfect sales forecast, expense report, or personal budget, you’ll probably want to reuse your hard work instead of starting from scratch. One approach is to save an extra copy of your workbook and just change the data for each new spreadsheet you want to create. That works fine, but it’s not terribly convenient.

Excel provides a more streamlined option with templates, which are spreadsheet blueprints that you can use to create new files. Templates don’t necessarily hold any data (although they can if you want them to). Instead, their main role in life is letting you format them to your heart’s content—adding things like column titles, fancy shading, and complex formulas—so that every time you want a worksheet that looks like the template, all you have to do is select the template and voilà! A new file appears, containing all the design elements you created in the original template.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint