# Customizing Header Label Text

Explore the various techniques for setting custom header labels in Spread component and improve the organization and presentation of your data. Access detailed examples and instructions for customizing header label text.

## Content

By default the Spread 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 add 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/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/hdrcustomtext.png)
To specify the custom text for a header label, you can use the **Label** property of the ColumnHeader.Column or RowHeader.Row shortcut objects or you can use the [Text](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Text.html) property of the Cells shortcut objects. For headers with multiple columns and multiple rows, you use the **Text** property of the Cells shortcut objects. Refer to the example in [Creating a Header with Multiple Rows or Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header/spwin-headermulti). For more information on the individual properties, refer to the [Label](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.Label.html) property in the [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html) class or the [Label](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.Label.html) property in the [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html) class.
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 specifying header cell coordinates.

## Using the Properties Window

1. At design time, in the **Properties** window, select the Spread 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.
    You cannot add or change custom text in cells other than changing 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**.

## Method to set

If you want to change the label display of the column header, refer to the target column in the Columns property of the ColumnHeader class, and after that, set custom text in [Label](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.Label.html) property of [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html) class. If you want to change the label display of the row header, refer to the target row in the Rows property of RowHeader class and set custom text to [Label](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.Label.html) property of [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html) class.

## 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].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).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 tab for the sheet for which you want to set custom header text.
2. Select the row or column for which you want to set custom header text, then right-click and choose **Headers**.
3. In the **Header Editor**, double-click the header for which you want to display custom text.
    If there is only one header row or column, click the one displayed cell with the text "".
4. Edit the text to be the custom text you want, and then press **Enter** to stop editing.
5. When you have edited all the header text you want to edit, click **OK** to close the **Header Editor**, then click **Yes** to apply your changes to the selection.
6. From the **File** menu choose **Apply and Exit** to apply your changes to the component and exit Spread Designer.

## See Also

[Setting the Header Text](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header/spwin-headertext)
[Customizing the Default Header Labels](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header/spwin-headertext/spwin-headerautotext)