Provides friendly Word processing, Spreadsheets & Presentation software.

|
Kingsoft Office > Support for Windows Office > How to add a new template to your Spreadsheets and set it as default?

How to add a new template to your Spreadsheets and set it as default?

Release Date: 07-08-13

Spreadsheets 2013 provides ready-made worksheet templates for common uses. These predesigned templates contain standard or boilerplate text, but you can modify them to fit your needs, or you can create a whole new template yourself. This tutorial will teach you “How to add a customized new template to your Spreadsheets and use it as the default template”.

3 steps to add a customized template to your Spreadsheets:

Step 1. Create a spreadsheet template:

Open a spreadsheet document. Set the font size, row/column number or other settings and save it as a .ett file.

Step 2. Put the new file under the catalog of Kingsoft template.

For example: C:\Program Files\kingsoft\Kingsoft Office\templates\1033\et\Personal.

Step 3. Close the program and re-launch it.

The template will appear as seen in the following.

 Add customized template in Excel

How to set the spreadsheets as default template?

Step 1: Launch the Templates dialog box. Click Spreadsheets button->New->New from Other Templates

 set the spreadsheets as default template

Step 2: Find the template you would like to set as the default template. Then check the Set as default template option. As shown in the below.

 set the spreadsheets as default template

Step 3: Click OK to finish