# Columns

When using the `saveExcel` method we can pass to it options for the customization of the columns that will be exported to Excel.

You can specify the following column options:

* [Hidden state](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/columns#hidden-state)
* [Locked state](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/columns#locked-state)
* [Templates](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/columns#templates)
* [Multi-column headers](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/columns#multi-column-headers)

## Hidden State

To hide a particular column from the exported file, use the [`hidden`](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/api/excelexportcolumnoptions#hidden) column configuration.

[Demo Source](https://demos.telerik.com/kendo-vue-ui/excel/columns/hidden/source.txt)

## Locked State

When exporting to Excel, we can lock columns by defining the [`locked`](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/api/excelexportcolumnoptions#locked) property for the selected columns. As a result, you can display specific columns at all times while the user scrolls the Excel file.

[Demo Source](https://demos.telerik.com/kendo-vue-ui/excel/columns/locked/source.txt)

## Templates

The Excel Export functionality supports templates that you can use for customizing the group and footer elements.

> The templates must return text content. HTML elements cannot be converted to Excel column values.

### Group Header Template

You can use the group header template to customize the header rows of the groups. To use a custom template set the [`groupHeader`](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/api/excelexportcolumnoptions#groupheader) property of selected column to a Function or a Vue Component.

[Demo Source](https://demos.telerik.com/kendo-vue-ui/excel/columns/group-header/source.txt)

### Group Footer Template

You can use the group footer template to customize the footer rows of the groups. To use a custom template set the [`groupFooter`](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/api/excelexportcolumnoptions#groupfooter) property of a column to a Function or a Vue Component.

[Demo Source](https://demos.telerik.com/kendo-vue-ui/excel/columns/group-footer/source.txt)

### Footer Template

You can use the footer template to customize the column footer. To use a custom template set the [`footer`](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/api/excelexportcolumnoptions#footer) property of selected column to a Function or a Vue Component .

[Demo Source](https://demos.telerik.com/kendo-vue-ui/excel/columns/footer/source.txt)

## Multi-Column Headers

The `saveExcel` method supports multi-column headers by using column groups.

[Demo Source](https://demos.telerik.com/kendo-vue-ui/excel/columns/multi/source.txt)

## Suggested Links

* [API Reference of the Excel Export functionaity](https://www.telerik.com/kendo-vue-ui-develop/components/excel-export/api)