Microsoft Office Tutorials and References
In Depth Information
Changing a Template
For Your Information: Customizing the Excel Blank Template
In previous versions of Excel, when you saved workbook settings
you used in the blank workbook template called Book.xltx that is
stored in the XLStart folder (typically C:\Users\ user name \Ap-
pData\Local\Microsoft\Excel\XLStart), the template automatically
opened when you created a blank template. In Excel 2013, the blank
workbook is not automatically created with Book.xltx when you start.
If you want to still use Book.xltx as a custom blank workbook, click the
File tab, click Options, click General, deselect the Show the Start screen
when this application starts check box ( New ! ), and then click OK.
Changing a Template
Office has a selection of premade Excel templates designed for you to use. These tem-
plates are available in the Start or New screen under Featured ( New ! ). If you like one
of these templates, you can use it as the basis of your own template. To customize one,
open the template, make the changes you want, and then save it. If you save the original
template back in the same location with the same name as the original, you create a new
default template. The original one is replaced by the newly saved template. If you don’t
want to change the original, save the template in your My Templates or Custom Office
Templates folder.
Change an Excel Template
Click the File tab, and then click New .
Open the template you want to change using the following:
Featured Templates. Click Featured , and then click the template you want,
and then click Create .
Personal Templates. Click Personal , and then click the custom template
you want.
Search JabSto ::




Custom Search