# Displaying the Sheet Names

Customize the display of the sheet names in the Command bar by setting the count of sheet name tabs,  setting the increment for advancing the sheet names, etc.

## Content

You can customize how and if to display the sheet names in the bar at the bottom of the component. Since a component may have more than one sheet, the tabs (or buttons) in the command bar contain the sheet names and provide a way to navigate to different sheets. These are called sheet name tabs. The default sheet names are Sheet0, Sheet1, etc. You can specify other names for the sheets and these appear in the sheet name tabs. By default, the component has only one sheet and so no sheet name tabs are displayed. When you add a sheet, as described in [Adding a Sheet](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearSheet/spweb-SheetAdd), the sheet name tabs are added to the command bar for display.
You can set how many sheet name tabs are displayed. If the number of tabs exceeds the value specified, an ellipses is displayed. Click the ellipses to display the next (or previous) set of sheet names. You can also set the increment for advancing the sheet names. Be sure not to set the increment bigger than the number displayed if you want to be able to see all the sheet name tabs. You can set which sheet number displays first. These are all properties of the [TabInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.html) class.

> !type=note
> **Note:** The sheet changes when you click a different sheet name tab or when you click on the ellipses. When you click on the ellipses, the lowest number sheet in the set of sheet names is displayed.

![Parts of the Command Bar](https://cdn.mescius.io/document-site-files/images/346c9178-0ed8-4fb9-908b-1565b22fb408/artwork/partsofcommandbar.png)

## Using Code

1. To define when the sheet name tabs are displayed, use the [TabControlPolicy](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.TabControlPolicy.html) property of the [TabInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.html) class and the settings of the [TabControlPolicy](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabControlPolicy.html) enumeration.
2. Determine the various settings using the [Tab](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.Tab.html) property of the [FpSpread](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.html) component. Determine how many sheet name tabs to display using the [VisibleCount](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.VisibleCount.html) property, how many to increment with the [ScrollIncrement](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.ScrollIncrement.html) property, and which is the first visible sheet name with the [FirstVisibleTab](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.FirstVisibleTab.html) property of the [TabInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.html) class.
3. Determine the appearance of the sheet name tabs, such as the background color, the text color, and the text of the sheet name using the properties of the [TabInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TabInfo.html) class for the [Tab](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.Tab.html) property of the component.

## Example

In this example, set the sheet name tabs to always appear below the sheet at the bottom of the component and show only two sheet names (two tabs) and set the background color of the active tab to green.

```csharp
FpSpread1.Sheets.Count = 3;
FpSpread1.Tab.TabControlPolicy = FarPoint.Web.Spread.TabControlPolicy.Always;
FpSpread1.Tab.VisibleCount = 2;
FpSpread1.Tab.ScrollIncrement = 2;
FpSpread1.Tab.FirstVisibleTab = 1;
FpSpread1.Tab.TextColor = Color.Yellow;
FpSpread1.Tab.ActiveTabBackColor = Color.Green;
FpSpread1.Tab[0] = "First";
FpSpread1.Tab[1] = "Second";
FpSpread1.Tab[2] = "Third";
```

```vbnet
FpSpread1.Tab.TabControlPolicy = FarPoint.Web.Spread.TabControlPolicy.Always
FpSpread1.Sheets.Count = 3
FpSpread1.Tab.VisibleCount = 2
FpSpread1.Tab.ScrollIncrement = 2
FpSpread1.Tab.FirstVisibleTab = 1
FpSpread1.Tab.ActiveTabBackColor = Color.Green
FpSpread1.Tab.TextColor = Color.Yellow
FpSpread1.Tab(0) = "First"
FpSpread1.Tab(1) = "Second"
FpSpread1.Tab(2) = "Third"
```

## Using the Spread Designer

1. Select the **Settings** menu.
2. Select the **General** icon under the **Spread Settings** section.
3. Select **Tab** and specify the policy settings.
4. Click **OK**.
5. Click **Apply and Exit** to close the Spread Designer.