# Customizing Header Label Text

Customize the default appearance of header cells by adding labels to them using Spread for ASP.NET. Learn more in documentation.

## Content

By default the component displays letters in the column headers and numbers in the row headers. Besides this automatic text, you can add labels to any or all of the header cells. You can customize the header label text, as shown in the following figure where the first four columns have custom labels.
![Spread with custom column header text](https://cdn.mescius.io/document-site-files/images/346c9178-0ed8-4fb9-908b-1565b22fb408/artwork/hdrcustomtext.png)
To specify the custom text for a header label, you can use the [Column](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.html) [Label](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.Label.html) property or the [Row](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.html) [Label](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.Label.html) property or you can use the [Cell](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cell.html) [Text](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cell.Text.html) property. For headers with multiple columns and multiple rows, you use the [Text](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cell.Text.html) property of the Cells shortcut objects. Refer to the example in [Creating a Header with Multiple Rows or Columns](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearHeader/spweb-HeaderMulti).
To customize the sequential letters in column headers and sequential numbers in row headers that are displayed by default, refer to [Customizing the Default Header Labels](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearHeader/spweb-HeaderAutoText).
Cells in the headers are separate from the cells in the data area, so the coordinates for cells in the headers start at 0,0 and count up from upper left to lower right within the header. The sheet corner cell is separate and is not counted when figuring header cell coordinates.

## Using the Properties Window

1. At design time, in the **Properties** window, select the FpSpread component.
2. Select the **Sheets** property.
3. Click the button to display the **SheetView Collection Editor**.
4. Click the sheet for which you want to change the header labels.
<br>
    You cannot add or change custom text in cells other than the labels displayed when using the **Properties** window.
5. In the property list, select the Cells property and click the button to display the **Cell, Column, and Row Editor**.
6. Select the column for which you want to change the labels displayed to custom text.
7. Set the Label property to set the custom text.
8. Click **OK** to close the **Cell, Column, and Row Editor**.
9. Click **OK** to close the **SheetView Collection Editor**.

## Using a Shortcut

* If you want to change the text in a header cell or display text in a cell, set the Text property for the [Cells](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cells.html) object of the [ColumnHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.ColumnHeader.html) to the custom text you want to display. If you want to set the text for multiple header cells, call the [SetClip](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.ColumnHeader.SetClip.html) or [SetClipValue](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.ColumnHeader.SetClipValue.html) methods for the [ColumnHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.ColumnHeader.html). The same applies to a [RowHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.RowHeader.html) object.
* If you want to change the labels displayed, set the [Label](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.Label.html) property for the [Columns](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Columns.html) object to the custom text you want to display.

## Example

This example code sets custom text for the labels in the first four column headers.

```csharp
// Set custom text for columns A through D.
FpSpread1.Sheets[0].ColumnCount = 4;
FpSpread1.Sheets[0].ColumnHeader.Columns[0].Label = "North";
FpSpread1.Sheets[0].ColumnHeader.Columns[1].Label = "South";
FpSpread1.Sheets[0].ColumnHeader.Columns[2].Label = "East";
FpSpread1.Sheets[0].ColumnHeader.Columns[3].Label = "West";
```

```vbnet
' Set custom text for columns A through D.
FpSpread1.Sheets(0).ColumnCount = 4
FpSpread1.Sheets(0).ColumnHeader.Columns(0).Label = "North"
FpSpread1.Sheets(0).ColumnHeader.Columns(1).Label = "South"
FpSpread1.Sheets(0).ColumnHeader.Columns(2).Label = "East"
FpSpread1.Sheets(0).ColumnHeader.Columns(3).Label = "West"
```

## Using the Spread Designer

1. Select the sheet at the bottom of the designer.
2. Select the **Settings** menu.
3. Select the **Header** editor in the **Other Settings** section.
4. Select the header you wish to edit.
5. Set the **Label** property in the property grid.
6. Choose **Apply** and **OK** to apply your changes to the component.
7. Click **Apply and Exit** to close the Spread Designer.