# Specifying What the User Can Select

With Spread for ASP.NET, you can customize what the user can select and edit on a spreadsheet. Learn more in documentation.

## Content

By default, the component allows users to select a cell, a column, a row, a range of cells, or the entire sheet. You can customize what the user can select by working with the operation mode of the sheet ([OperationMode](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.OperationMode.html) property). The settings are based on the [OperationMode](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.OperationMode.html) enumeration. You can specify what the user is allowed to select in normal operation mode with the [SelectionBlockOptions](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.SelectionBlockOptions.html) property. You can allow the user to select multiple blocks in normal operation mode with the [SelectionPolicy](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.SelectionPolicy.html) property.
The settings of the [OperationMode](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.OperationMode.html) property affect user interaction with the sheet, that is, what the user can select, but not necessarily what the application can select.
![Selected row and editable cell](https://cdn.mescius.io/document-site-files/images/346c9178-0ed8-4fb9-908b-1565b22fb408/artwork/selection-rowlabeled.png)
The following table summarizes the options available for specifying what users can select and edit on the sheet:

| **User can select** | **User can edit** | **OperationMode Setting** |
| --------------- | ------------- | --------------------- |
| Cell, row, column, any range of cells, entire sheet | Active cell | Normal |
| Only one row | Active Cell | RowMode |
| Only one row | Nothing | SingleSelect |
| Nothing | Nothing | ReadOnly |
| Multiple contiguous rows | Nothing | MultiSelect |
| Multiple discontiguous rows | Nothing | ExtendedSelect |

## 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. In the **Members** list, select the sheet for which to set the operation mode.
5. Select the **OperationMode** property, then select one of the values from the drop-down list of values.
6. Click **OK** to close the editor.

## Using a Shortcut

1. To set the overall user interaction mode of the sheet, set the Sheet’s [OperationMode](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.OperationMode.html) property.

**Example**
This example code sets the sheet to allow users to select only rows and only edit the active cell.

```csharp
// Set the operation mode and let users select only rows.
fpSpread1.Sheets[0].OperationMode = FarPoint.Web.Spread.OperationMode.RowMode;
```

```vbnet
' Set the operation mode and let users select only rows.
FpSpread1.Sheets(0).OperationMode = FarPoint.Web.Spread.OperationMode.RowMode
```

## Using Code

1. To set the overall user interaction mode of the sheet, set the [OperationMode](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.OperationMode.html) property for a [SheetView](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.html) object.
2. Assign the [SheetView](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.html) object you have created to one of the sheets in the component.

**Example**
This example code sets the sheet to allow users to select only cells or ranges of cells, including multiple ranges of cells. They cannot select columns, rows, or the entire sheet.

```csharp
// Set operation mode and let users select only a row.
FarPoint.Web.Spread.SheetView newsheet = new FarPoint.Web.Spread.SheetView();
newsheet.OperationMode = FarPoint.Web.Spread.OperationMode.RowMode;
// Assign the SheetView object to a sheet.
fpSpread1.Sheets[0] = newsheet;
```

```vbnet
' Set operation mode and let users select only a row.
Dim newsheet As New FarPoint.Web.Spread.SheetView()
newsheet.OperationMode = FarPoint.Web.Spread.OperationMode.RowMode
' Assign the SheetView object to a sheet.
FpSpread1.Sheets(0) = newsheet
```

## Using the Spread Designer

1. Select the sheet tab for the sheet for which you want to set the selection operation mode.
2. From the **Settings** menu, select the **General** icon, then select one of the choices from the **Operation Mode** area.
3. Click **OK** to close the **Sheet Settings** dialog.
4. From the **File** menu choose **Apply and Exit** to apply your changes to the component and exit Spread Designer.