Excel® 2013 On Demand

Creating a Personal Template

You can create your own personal template as easily as you create a worksheet. Like those that come with Excel, custom templates can save you time. Perhaps each month you create an inventory worksheet in which you enter repetitive information; all that changes is the actual data. By creating your own template, you can have a custom form that is ready for completion each time you take inventory. A template file (.xltx) saves all the customization you made to reuse in other workbooks. You can store your template anywhere you want; you may find it handy to store it in a My Templates folder (New!), or the default Custom Office Templates folder (New!). When you set up the default personal templates folder in the Options ...