# Set Range Template Cell

## Content

SpreadJS provides support for a Range Template cell that allows you to define a template of cell ranges as a single celltype and apply that template to a cell to load different types of data into the template. Now, you can directly create a range template celltype through the designer also.

The following steps should be performed to create a range template cell in the spreadsheet through the designer.

1. Create a template by designing the range of cell in the spreadsheet. You can also select the existing template.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/CreateTemplate.png)
2. Select the range where you want to insert the template.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/SelectRange.png)
3. After selecting the range, go to **Home** tab, click on the **Cell Type** option and select the **Range Template** celltype.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/SetRangeTemplate.png)
4. Range Template dialog box appears with two options as shown below.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/SelectRangeTemplate.png)
    * Set the sheet on which you want to insert the range template. Make sure that you always use the current active spreadsheet.
    * Select or set the range of created or existing template.
5. Click OK after setting the above options.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/RangeTemplateDialog.png)
6. After clicking OK button, range template cell is set to the selected range.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/SetRangeTemplateDialog.png)

> **Note:** When you select the range in the **Range** option, select only one range of the template. If you select multiple range, the designer will pick only the first range.