# Allowing the User to Resize Rows or Columns

Learn how you can allow a user to readjust the size of a row or column in the spreadsheet using Spread for ASP.NET.

## Content

You can allow the user to readjust the size of a row or column in the sheet. Set the [Resizable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.Resizable.html) property for the row to allow the user to resize rows and the [Resizable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.Resizable.html) property for the column to allow the user to resize columns.
For users to resize rows or columns, they simply left click on the edge of the header of the row or column to resize and drag the side of the header and release the mouse at the desired size. While the left mouse button is down, a bar is displayed along with the resize pointer as shown in the figure below. Be sure to click on the right edge of the column and bottom edge of the row.
![Resize Icon](https://cdn.mescius.io/document-site-files/images/346c9178-0ed8-4fb9-908b-1565b22fb408/artwork/headerresize.png)
By default, user resizing of rows or columns is allowed for rows and columns in the data area and not allowed for the header area. In code, you can resize row and column headers, not just data area rows and columns. You can override the default behavior using the **Resizable** property and prevent the user from resizing.
You can determine if a row or column can be resized by the user with these methods in the [SheetView](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.html) class:

* [GetColumnSizeable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.GetColumnSizeable.html)
* [SetColumnSizeable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.SetColumnSizeable.html)
* [GetRowSizeable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.GetRowSizeable.html)
* [SetRowSizeable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.SetRowSizeable.html)

## Using Code

Set the [Resizable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.Resizable.html) property.

## Example

This example code sets the [Resizable](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.Resizable.html) property.

```csharp
FpSpread1.Sheets[0].Columns[0].Resizable = true;
FpSpread1.Sheets[0].Rows[0].Resizable = true;
FpSpread1.Sheets[0].Columns[1].Resizable = false;
FpSpread1.Sheets[0].Rows[1].Resizable = false;
```

```vbnet
FpSpread1.Sheets(0).Columns(0).Resizable = True
FpSpread1.Sheets(0).Rows(0).Resizable = True
FpSpread1.Sheets(0).Columns(1).Resizable = False
FpSpread1.Sheets(0).Rows(1).Resizable = False
```

## Using the Spread Designer

1. Select a column or row.
2. Set the **Resizable** property in the **Property Grid**.
3. Click **Apply and Exit** to close the Spread Designer.

## See Also

[Resizable Property](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.Resizable.html)