# Customizing the Position in the Display

Learn how to customize the position of spreadsheet data in the display using the FpSpread class and its methods. Scroll to the specified item in the specified location for optimal display.

## Content

You can customize the position of the data area of the spreadsheet in the display by choosing a row, column, or cell, and moving it to a particular position in the displayed portion of the spreadsheet in the Spread component.
Use the [ShowRow](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ShowRow.html), [ShowColumn](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ShowColumn.html), [ShowCell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ShowCell.html), or [ShowActiveCell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ShowActiveCell.html) methods in the [FpSpread](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.html) class, and the [HorizontalPosition](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.HorizontalPosition.html) and [VerticalPosition](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.VerticalPosition.html) enumerations. These methods scroll the display until the specified item is displayed in the specified location.

## Using Code

Set the [ShowActiveCell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ShowActiveCell.html) method.

## Example

This example sets the active cell and then displays the cell in the top, center of the spreadsheet.

```csharp
fpSpread1.Sheets[0].SetActiveCell(3,4);
fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Top, FarPoint.Win.Spread.HorizontalPosition.Center);
```

```vbnet
fpSpread1.Sheets(0).SetActiveCell(3,4)
fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Top, FarPoint.Win.Spread.HorizontalPosition.Center)
```

## See Also

[Customizing the Scroll Bars](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-scroll/spwin-cntrlscrollbars)
[Customizing Scroll Bar Tips](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-scroll/spwin-cntrl-scrolltips)
[Wrapping the Header Text](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header/spwin-wrap-header-text)