# Creating a Range of Cells

Learn how to create a range of cells and define properties using drag-and-drop or code in Spread.NET.

## Content

You can create a range of cells to allow you to define properties and behaviors for those cells. A range may be any set of cells.
To fill ranges using drag-and-drop or drag-and-fill actions, refer to [Using Drag Operations to Fill Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cell-dragops).

## Using Code

1. Define a range of cells using the [Cell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.html) object.
2. Set properties for the range such as the [Note](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Note.html) property.

## Example

This example code sets the [Note](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.Note.html) property for a range of [Cell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.html) objects.

```csharp
FarPoint.Win.Spread.Cell range1;
range1 = fpSpread1.ActiveSheet.Cells[1, 1, 3, 3];
range1.Value = "Value Here";
range1.Note = "This is the note that describes the value.";
```

```vbnet
Dim range1 As FarPoint.Win.Spread.Cell
range1 = fpSpread1.ActiveSheet.Cells(1, 1, 3, 3)
range1.Value = "Value Here"
range1.Note = "This is the note that describes the value."
```

## Using the Spread Designer

In the **Cell, Column, or Row** editor and in the Spread Designer, select the cells that you want to be in the range. Properties you set are then applied to those cells.

## See Also

[Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell)
[Working with the Active Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellactive)
[Managing Data on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata)
[Displaying Cell Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-celldata)
[Creating a Span of Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellspan)
[Allowing Cells to Merge Automatically](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellmerge)
[Adding a Note to a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cell-note)
[Adding a Tag to a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-tags-cell)
[Displaying Text Tips in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cell-texttip)
[Working with Pattern and Gradient Fill Effects](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-patternandgradientfill)