Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Chapter 10. Customizing Excel to the Way... > Saving a Workbook as a Template

Saving a Workbook as a Template

If you use the same workbook frequently, such as for entering the time you spent on projects during a week or tracking travel expenses, you will find that using a template saves you and your colleagues a lot of work. Saving a workbook is a straightforward process; all you need to do is create a workbook that contains the number of worksheets, formulas, and formatting you want and then save the workbook in the appropriate format.

Save a Workbook as a Template

Click the Microsoft Office button.

Click Save As.

Click the Save As Type down arrow.

Click Excel Template.

Type the name you want for the template.

Click Save.


Be sure you don’t change the directory where Excel offers to save your template. If you do change it, your template won’t show up in the list of available templates. You could still open it by navigating to the folder in which you saved it, of course.


You should remove any existing data from a workbook you save as a template, both to avoid data entry errors and to remove any confusion as to whether the workbook is a template. The one exception to this rule is when your template contains formulas that would result in an error if you delete all data from the worksheet. In that case, you should enter some obviously incorrect data that future users know to replace.


You are currently reading a PREVIEW of this book.


Get instant access to over $1 million worth of books and videos.


Start a Free 10-Day Trial

  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint