# Setting the Top Row to Display

Spread for ASP.NET allows you to set the display of a spreadsheet to display a particular row as the top row. Learn more in documentation.

## Content

You can set the display of a sheet to display a particular row as the top row with the SheetView.[TopRow](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.TopRow.html) property. Rows above that top row are not rendered in the client. Use the [ScrollTo](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-ScrollTo) method to move the specified cell.
If the [AllowPage](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.AllowPage.html) property is False, the TopRow property takes effect. If [AllowPage](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.AllowPage.html) is True; then TopRow only takes effect the first time the page is loaded.

## Using Code

1. Set the [AllowPage](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.AllowPage.html) property.
2. Set the [TopRow](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.TopRow.html) property.

## Example

This example code sets the top row.

```csharp
FpSpread1.ActiveSheetView.RowCount = 20;
FpSpread1.ActiveSheetView.ColumnCount = 7;
FpSpread1.ActiveSheetView.AllowPage = false;
FpSpread1.ActiveSheetView.TopRow = 4;
FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = false;
```

```vbnet
FpSpread1.ActiveSheetView.AllowPage = False
FpSpread1.ActiveSheetView.ColumnCount = 7
FpSpread1.ActiveSheetView.RowCount = 20
FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = False
FpSpread1.ActiveSheetView.TopRow = 4
```

## See Also

[ScrollTo](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-ScrollTo)