# Showing or Hiding a Sheet

Use Spread for ASP.NET to hide a sheet so that it is not displayed to the user. Hiding a sheet does not remove it or affect any formulas on that sheet.

## Content

You can hide a sheet so that it is not displayed to the user while still keeping it in the component.
Hiding a sheet does not change the default sheet names provided to the other sheets. For example, a component with three sheets would by default name them Sheet1, Sheet2, and Sheet3. If you hide the second sheet, the names for the remaining sheets are Sheet1 and Sheet3.
Hiding a sheet does not remove it and does not affect formulas on that sheet or references to that sheet. For more information on removing the sheet completely, refer to [Removing a Sheet](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearSheet/spweb-SheetRemove). Use the [Visible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.Visible.html) property of the [FpSpread](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.html) component to show or hide the sheet.

## Using the Properties Window

1. At design time, in the **Properties** window, select the **Sheets** property for the FpSpread component.
2. Click the button to display the **SheetView Collection Editor**.
3. In the **Members** list, select the sheet to hide.
4. Select the **Visible** property in the property list and set to false.
5. Click **OK** to close the editor.

## Using a Shortcut

Set the [Visible](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.Visible.html) property of the [FpSpread](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.html) component [Sheets](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.Sheets.html) shortcut.

## Example

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

```csharp
// Hide the second sheet.
FpSpread1.Sheets[1].Visible = false;
```

```vbnet
' Hide the second sheet.
FpSpread1.Sheets[1].Visible = False
```