# Showing or Hiding a Sheet Explore various techniques to hide and unhide sheets in your Spread component with simple and effective methods. ## Content If you have more than one sheet in the component, you can hide a sheet so that it is not displayed to the user. Even though it is not displayed, it is not removed from the component. There must be at least one sheet in the component. For information on adding a sheet, refer to [Adding a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetadd). Hiding a sheet does not change the default sheet names provided for the other sheets. For example, a Spread 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. ## 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 hide. 5. Select the **Visible** property in the property list, and then select false. 6. Click **OK** to close the editor. ## Method to set Set the Sheets shortcut object [Visible](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.Visible.html) property for the sheet. ## Example This example code hides the second and fourth sheets in a Spread component that has eight sheets. ```csharp private void Form1_Load(object sender, System.EventArgs e) { // Set the Spread to have eight sheets. fpSpread1.Sheets.Count = 8; // Hide the second and fourth sheets. fpSpread1.Sheets[1].Visible = false; fpSpread1.Sheets[3].Visible = false; } ``` ```auto Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load ' Set the Spread to have eight sheets. fpSpread1.Sheets.Count = 8 ' Hide the second and fourth sheets. fpSpread1.Sheets(1).Visible = False fpSpread1.Sheets(3).Visible = False End Sub ``` ## Using the Tab Strip Context Menu You can hide a sheet by using the tab strip's context menu and choosing 'Hide' option. The tab strip context menu can be enabled by setting the **Editable** option as true. ```csharp fpSpread1.TabStrip.Editable = true; ``` ![](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sheet-hide.png) Similarly, you can select 'Unhide' from tab strip context menu to unhide sheets. The 'Unhide' dialog listing all the hidden sheets is opened from which you can select the ones you want to unhide. ![](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sheet-unhide.png) ## Using the Spread Designer 1. Select the sheet tab for the sheet for which you want to set properties. 2. In the property list, select the **Visible** property. 3. Select **False**. 4. From the **File** menu choose **Apply and Exit** to apply your changes to the component and exit Spread Designer. You can choose 'Hide' and 'Unhide' options from tab strip context menu in Spread Designer as well. However, these options can be disabled by checking the “Show hidden sheets” option in 'Preferences' dropdown list (unchecked by default). This will ensure that the hidden sheets are always shown. ![](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sheet-prefmenu.png) ## 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) [Removing a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetremove) [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) [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) [Removing a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetremove) [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)