ExcelBanter - Personal format of an excel spreadsheet as a template?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Personal format of an excel spreadsheet as a template? (https://www.excelbanter.com/new-users-excel/4900-personal-format-excel-spreadsheet-template.html)

Nukinhawg

Personal format of an excel spreadsheet as a template?

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?

Gord Dibben

Create a new workbook with one sheet and format as you wish.

FileSave AsFile TypeTemplate(*.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 InsertWorksheet.

Gord Dibben Excel MVP

On Wed, 19 Jan 2005 17:29:01 -0800, Nukinhawg
wrote:

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?

All times are GMT +1. The time now is 06:10 AM.