# Showing or Hiding Headers

Customize the default appearance of header cells by hiding the row headers, column headers, or both using Spread for ASP.NET.

## Content

By default, the row headers and column headers are displayed in the component. You can hide the row headers, the column headers, or both. The following figure shows a sheet that displays only column headers and hides the row headers.
![Spread with no row headers](https://cdn.mescius.io/document-site-files/images/346c9178-0ed8-4fb9-908b-1565b22fb408/artwork/norowhdr.png)
If the sheet has multiple headers, using the property window instructions to hide the headers, hides all header rows or header columns or both. If you want to hide specific rows or columns within a header, you must specify the row or column. For more details on hiding specific rows or columns, refer to [Showing or Hiding Rows or Columns](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearRowCol/spweb-RowColHide).
The display of headers is done by simply setting the row header [Visible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.Visible.html) property or column header [Visible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.ColumnHeader.Visible.html) property.
Alternatively, if you prefer you can customize the headers by providing custom text or headers with multiple columns or rows, as explained in [Customizing Header Label Text](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearHeader/spweb-HeaderContent) and [Creating a Header with Multiple Rows or Columns](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearHeader/spweb-HeaderMulti).

## 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 display.
5. Set the **Visible** property for the ColumnHeader object or the **Visible** property for the RowHeader object to false to turn off the display of the header.
6. Click **OK** to close the editor.

## Using a Shortcut

Set the [ColumnHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.ColumnHeader.html) [Visible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.Visible.html) (or [SheetView](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.html) [ColumnHeaderVisible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.ColumnHeaderVisible.html)) property or [RowHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.RowHeader.html) [Visible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.Visible.html) (or [SheetView](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.html) [RowHeaderVisible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.RowHeaderVisible.html)) property for a sheet.
**Example**
This example turns off the display of the row header.

```csharp
// Turn off the display of row headers.
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 4;
```

```vbnet
' Turn off the display of row headers.
FpSpread1.Sheets(0).RowHeader.Visible = False
FpSpread1.Sheets[0].ColumnCount = 4
```

## Using Code

1. Create a new SheetView object.
2. Set the SheetView object [ColumnHeaderVisible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.ColumnHeaderVisible.html) or [RowHeaderVisible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.RowHeaderVisible.html) property to false.
3. Set an FpSpread component’s sheet equal to the SheetView object you just created.

**Example**
This example code sets the first sheet to not display column headers.

```csharp
// Create a new sheet.
FarPoint.Web.Spread.SheetView newsheet = new FarPoint.Web.Spread.SheetView();
newsheet.ColumnHeaderVisible = false;
// Set first sheet equal to SheetView object.
FpSpread1.Sheets[0] = newsheet;
```

```vbnet
' Create a new sheet.
Dim newsheet As New FarPoint.Web.Spread.SheetView()
newsheet.ColumnHeaderVisible = False
' Set first sheet equal to SheetView object.
FpSpread1.Sheets(0) = newsheet
```

## Using the Spread Designer

1. Select the sheet tab for the sheet for which you want to turn off header display.
2. In the **View** menu select or deselect the **Row Header** or **Column Header** check box.
3. From the **File** menu choose **Apply and Exit** to apply your changes to the component and exit Spread Designer.