# Removing a Sheet

Learn how to remove multiple sheets from the Spread component and change sheet count or explicitly remove sheets by specifying their indexes.

## Content

If you have multiple sheets, you can remove a sheet or remove several sheets from the Spread component. There must always be at least one sheet in the component.
In code, you can simply change the sheet count or you can explicitly remove the sheets by specifying their indexes. The sheet index is zero-based.
Removing an existing sheet does not change the default sheet names provided to the other sheets. For example, a Spread component with three sheets would by default name them Sheet1, Sheet2, and Sheet3. If you remove the second sheet, the names for the remaining sheets are Sheet1 and Sheet3. The indexes for the sheets are 0 and 1, because the sheet index is zero based.
You can also hide a sheet. For more information, refer to [Showing or Hiding a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheethide).
To remove an existing sheet, complete the following instructions.

## Using the Properties Window

1. At design time, in the **Properties** window, select the Spread component.
2. Select the **Sheets** property.
3. Click the button to display the **SheetView Collection Editor**.
4. In the **Members** list, select the sheet to remove.
5. Click the **Remove** button to remove the sheet from the collection.
6. Click **OK** to close the editor.

## Method to set

Call the Sheets shortcut object [Remove](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetViewCollection.Remove.html) method (to remove the sheet from the [SheetViewCollection](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetViewCollection.html) for the component) and specify the sheet to remove.

## Example

This example code removes the second sheet from a Spread component that has two or more sheets.

```csharp
// Remove the second sheet.
fpSpread1.Sheets.Remove(fpSpread1.Sheets[1]);
```

```vbnet
' Remove the second sheet.
fpSpread1.Sheets.Remove(fpSpread1.Sheets(1))
```

## See Also

[Sheets](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet)
[Working with the Active Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetactive)
[Working with Multiple Sheets](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetmulti)
[Adding a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetadd)
[Showing or Hiding a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheethide)
[Moving a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheet-move)
[Copying and Inserting a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetcopy)
[Adding a Title and Subtitle to a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheettitle)
[Placing Child Controls on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheet-childcontrols)
[Displaying a Footer for Columns or Groups](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-columnfooter)
[Adding a Tag to a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-tags-sheet)
[Working with 1-Based Indexing](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/working-with-1based-indexing)