# Expanding Cells

By default, a cell is displayed in a single row and column.

However, you can configure a cell to occupy more than one row or column.

## Spanning across Columns

To expand a cell across two or more columns, set the [`colSpan`](https://www.telerik.com/kendo-jquery-ui/documentation/api/ooxml/workbook/configuration/sheets/rows/cells#sheetsrowscellscolspan) option. As a result, all cells will follow shift to the right with the same number of columns as defined by the `colSpan`.

```dojo
<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
    {
      rows: [
        {
          cells: [
            { value: "A1, B1 and C1", colSpan: 3 }, { value: "D1" }
          ]
        }
      ]
    }
  ]
});
workbook.toDataURLAsync().then(function (dataURI) {
    kendo.saveAs({
      dataURI: dataURI,
      fileName: "Test.xlsx",
    });
});
</script>
```

## Spanning across Rows

To expand a cell across two or more rows, set the [`rowSpan`](https://www.telerik.com/kendo-jquery-ui/documentation/api/ooxml/workbook/configuration/sheets/rows/cells#sheetsrowscellsrowspan) option.

```dojo
<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
    {
      rows: [
        {
          cells: [
            { value: "A1 and A2", rowSpan: 2 }, { value: "B1" }
          ]
        },
        {
          cells: [
            { value: "B2" }
          ]
        }
      ]
    }
  ]
});
workbook.toDataURLAsync().then(function (dataURI) {
    kendo.saveAs({
      dataURI: dataURI,
      fileName: "Test.xlsx",
    });
});
</script>
```

## Spanning across Rows and Columns

To span a cell across two or more rows and columns simultaneously, use both the `colSpan` and `rowSpan` options.

```dojo
<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
    {
      rows: [
        {
          cells: [
            { value: "A1, B1, A2 and B2", rowSpan: 2, colSpan: 2 }
          ]
        }
      ]
    }
  ]
});
workbook.toDataURLAsync().then(function (dataURI) {
    kendo.saveAs({
      dataURI: dataURI,
      fileName: "Test.xlsx",
    });
});
</script>
```

## See Also

* [Introduction to the Excel Export Functionality](https://www.telerik.com/kendo-jquery-ui/documentation/framework/excel/introduction)
* [Customizing the Appearance](https://www.telerik.com/kendo-jquery-ui/documentation/framework/excel/appearance)
* [Freezing Rows and Columns](https://www.telerik.com/kendo-jquery-ui/documentation/framework/excel/freeze-pane)
* [Setting the Column Width](https://www.telerik.com/kendo-jquery-ui/documentation/framework/excel/column-width)
* [Creating Multiple Sheets](https://www.telerik.com/kendo-jquery-ui/documentation/framework/excel/sheets)
* [Exporting the Kendo UI DataSource to Excel](https://www.telerik.com/kendo-jquery-ui/documentation/framework/excel/extract-datasoruce)