Workbook and Worksheet Templates

Create Default Workbook Template (book.xlt)

1. Create a blank workbook, customized with number of sheets, fonts, styles etc.
2. Hit F12 to save the workbook, in the 'Save As Type' dropdown, choose 'Template'
3. For the filename, type 'book' (to save the template as book.xlt in your XLSTART folder)

This will be the default workbook whenever you start Excel.

Create Default Worksheet Template (sheet.xlt)

1. Create a blank worksheet, customized with fonts, styles, zoom etc.
2. Hit F12 to save the workbook, in the 'Save As Type' dropdown, choose 'Template'
3. For the filename, type 'sheet' (to save the template as sheet.xlt in your XLSTART folder)

This will be the default worksheet whenever you Insert>Worksheet (or Shift-F11).