# Customizing the Number of Rows or Columns

Spread for ASP.NET allows you to customize the number of rows and columns upto two billion rows and columns. Learn more in documentation.

## Content

When you create a sheet, it is automatically created with three rows and four columns. You can change the number to up to two billion rows and columns.

## 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. Set **RowCount** and **ColumnCount** under the **Layout** section.
5. Click **OK** to close the editor.

## Using a Shortcut

Set the [RowCount](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.RowCount.html) or [ColumnCount](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.ColumnCount.html) property for the [Sheets](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.Sheets.html) shortcut.
**Example**
This example code sets the first sheet to have 10 columns and 100 rows.

```csharp
FpSpread1.Sheets[0].RowCount = 100;
FpSpread1.Sheets[0].ColumnCount = 10;
```

```vbnet
FpSpread1.Sheets(0).RowCount = 100
FpSpread1.Sheets(0).ColumnCount = 10
```

## Using Code

Set the [RowCount](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.RowCount.html) or [ColumnCount](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.ColumnCount.html) property for a [SheetView](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.html) class.

### **Example**

This example code sets the first sheet to have 100 rows and 10 columns.

```csharp
FarPoint.Web.Spread.SheetView Sheet0;
Sheet0 = FpSpread1.Sheets[0];
Sheet0.RowCount = 100;
Sheet0.ColumnCount = 10;
```

```vbnet
Dim Sheet0 As FarPoint.Web.Spread.SheetView
Sheet0 = FpSpread1.Sheets(0)
Sheet0.RowCount = 100
Sheet0.ColumnCount = 10
```

## Using the Spread Designer

1. Select the **Settings** menu.
2. At the bottom, select the sheet for which you want to set the number of rows or columns.
3. Select the **General** icon under the **Sheet Settings** section and change the **RowCount** or **ColumnCount** setting.
4. Click **OK**.
5. Click **Apply and Exit** to close the Spread Designer.