Personal format of an excel spreadsheet as a template?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use the format of an Excel spreadsheet that I have created as a
template for other worksheets in a book and other books. How can I accomplish
this, if possible?
 
Create a new workbook with one sheet and format as you wish.

File>Save As>File Type>Template(*.xlt)

Name it SHEET(Excel will add the .xlt extension.

Store this SHEET.XLT in your XLSTART folder.

It will be the default worksheet for Insert>Worksheet.


Gord Dibben Excel MVP
 
Back
Top