change excel Default template

change excel default template

Create a workbook with the number of worksheets you want, specify the styles etc.

Save it as a template named Book.xltx in the folder %appdata%\Microsoft\Excel\XLSTART.

The name Book.xltx is mandatory but it depends on the interface language. In the French version it would be Livre.xltx, and in the German version Buch.xltx.

Excel will use this template when you press Ctrl+N or click the New button that you can add to the Quick Access Toolbar.

Also create a version with a single worksheet and save it as a template named Sheet.xltx in the same folder. Again, Sheet.xltx is the obligatory name for the English version. This template will be used when you create a new worksheet in a workbook.