In earlier versions of Microsoft Excel, workbooks saved as templates where automatically saved into a Microsoft Templates folder. In Excel 2013, if you want to be able to save templates so that they become personal templates, you first need to create a folder in which to store your templates and then make that folder your default personal templates location.
To set the default templates location, click File – New. Click the Save tab. In the Default personal templates location box, enter the path to the templates folder you created e.g. C:\Users\Username\My Templates. Click OK.
Now all custom templates you save, by choosing Microsoft Excel Template from the Save as type dropdown in the Save or Save As dialog box will appear under Personal when you select File – New.