# Freeze Columns

## Three ways to freeze columns

We can freeze columns in many ways. Here is how,

### i. Freeze the column while adding a new one

1. Click on the `+` button to add a new column.
2. Provide column `Name`, `Key name` and rest of the values based on your choice.
3. Check `Frozen?` checkbox for the column.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FO6y9qJ4HogpNkkBO58gT%2Fimage.png?alt=media&#x26;token=6c1bc713-84ad-4a58-86ef-27647632d459" alt=""><figcaption><p>Freezing column while adding new one</p></figcaption></figure>

### ii. **Freezing already created column**

1. Click on the Pencil (Edit) icon for any created column.
2. Check the `Frozen?` checkbox.
3. Click on `Save`.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FTtR0CbOY9oP8gIE6aafr%2Fimage.png?alt=media&#x26;token=bb027a1c-1d7e-46b5-9bb1-a857b0d53808" alt=""><figcaption><p>Editing the column to mark it as freeze</p></figcaption></figure>

### iii. Freezing column with [Runtime Schema](https://docs.impler.io/features/runtime-schema)

We can freeze the column while providing a custom schema too with the `isFrozen` flag in our frontend code.

```javascript
showWidget({
  schema: [
    {
      key: 'email',
      name: 'Email',
      type: 'Email',
      isFrozen: true
    }
  ]
});
```

## Effects on Sample File Generation

The generated sample file will have specified columns freeze on the left side. So they won't gets hidden if we scroll to the right.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FVpa6tOdWOXcuHDg2Lal6%2Fimage.png?alt=media&#x26;token=f26d385b-86d2-4922-bb6e-0c5b22f442b6" alt=""><figcaption><p>Excel view of freezed columns</p></figcaption></figure>

## Effects on Spreadsheet Editor

While importing data spreadsheet editor freezes two default `Checkbox` and `Sr. No.` Columns. Other mentioned columns get frozen as per schema.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FYg9od5ybUCfqpidkxdpI%2Fimage.png?alt=media&#x26;token=764dbada-f686-4229-b6e8-2e93e253b301" alt=""><figcaption><p>Freezing 2 default and 2 mentioned columns in editor</p></figcaption></figure>

***

If you have any questions, suggestions, or comments. Feel free to reach out to us over [**Discord**](https://discord.impler.io). We’re constantly improving to deliver the best Data Importer for your product, and we value your input.
