# Set Range Template Cell

A tutorial showing how to set a range template cell in the SpreadJS Designer Component with UI

## 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.
    ![1](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/1.132db8.png?width=400)
<br>
2. Select the range where you want to insert the template.
    ![2](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/2.67c4c8.png?width=400)
<br>
3. After selecting the range, go to **Home** tab, click on the **Cell Type** option and select the **Range Template** celltype.
    ![3](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/3.c4fb2e.png?width=800)
<br>
4. Range Template dialog box appears with two options as shown below.
<br>
    ![4](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/4.795385.png?width=400)
    * 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.
    ![5](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/5.e915fa.png?width=400)
<br>
6. After clicking OK button, range template cell is set to the selected range.
<br>
    ![6](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/6.1571dc.png?width=400)

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