# Wrapping the Header Text

Use Spread.NET to develop front-ends to database applications. It gives access to multiple sheets using many types of cells and predefined sheet styles.

## Content



In Spread, you can customize text wrap in a column header by setting the **WrapText** property of [IRange](/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.IRange.html) Interface to true. Note that to view the wrapped text properly in the cell, you need to adjust the row height using the **RowHeight** property in the **ColumnHeader** class.

Before applying this WrapText property, ensure that the value of **ColumnHeaderRenderer.WordWrap2** property of the [SpreadSkin](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadSkin.html) class is set to null. If not, Spread uses the specified value of the [ColumnHeaderRenderer](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadSkin.ColumnHeaderRenderer.html) property as the default renderer to paint cells in the **ColumnHeader** area. By default, the **ColumnHeaderRenderer.WordWrap2** value is null for the Default skin only.

The following image depicts a preview of the wrapped text in the column header.

![](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/wraptextheader.png)

Use the sample codes below to wrap the column header text using the **IRange.WrapText** property.

```csharp
// Wrap text in column header
activeSheet.ColumnHeader.Cells.RowHeight = 90;
activeSheet.ColumnHeader.Cells[0, 0].Value = "This is a long header text";
activeSheet.ColumnHeader.Cells[0, 0].WrapText = true;
```

```vbnet
' Wrap text in column header
activeSheet.ColumnHeader.Cells.RowHeight = 90
activeSheet.ColumnHeader.Cells(0, 0).Value = "This is a long header text"
activeSheet.ColumnHeader.Cells(0, 0).WrapText = True
```