# Adding a Title and Subtitle to a Sheet

Use Spread for ASP.NET to add a specially formatted area at the top of the spreadsheet that includes either a title or a subtitle or both.

## Content

You can add a specially formatted area at the top of the spreadsheet that includes either a title or a subtitle or both. An example is shown here of a spreadsheet that has a title and a subtitle.
![Sheet with title and subtitle](https://cdn.mescius.io/document-site-files/images/346c9178-0ed8-4fb9-908b-1565b22fb408/artwork/titlesubtitle.png)
The title is set using the TitleInfo property at the FpSpread level. The subtitle is set using the [TitleInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.TitleInfo.html) property at the sheet level. So titles apply to the overall Spread component, while subtitles can be different for each sheet.
The API members that are involved include:

* [TitleInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TitleInfo.html) Class and all members
* SheetView [TitleInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.SheetView.TitleInfo.html) Property
* FpSpread [TitleInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.TitleInfo.html) Property

## Using the Properties Window

1. At design time, in the **Properties** window, select the FpSpread component or the sheet.
2. Select **TitleInfo**.
3. Set the **Visible** property to true and other properties as needed.
4. Click **OK** to close the editor.

## Using a Shortcut

Set the properties of the [TitleInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.TitleInfo.html) class at the FpSpread and Sheet level.

## Example

This example code sets and displays a title for the component and subtitle for the sheet.

```csharp
// Show the title for the entire spreadsheet component.
FpSpread1.TitleInfo.Visible = true;
FpSpread1.TitleInfo.Text = "FarPoint Spread Title";
// Show the subtitle for the individual sheet.
FpSpread1.Sheets[0].TitleInfo.Visible = true;
FpSpread1.Sheets[0].TitleInfo.Text = "Sheet Only Subtitle";
FpSpread1.Sheets[0].TitleInfo.HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].TitleInfo.BackColor = System.Drawing.Color.Aqua;
```

```vbnet
' Show the title for the entire spreadsheet component.
FpSpread1.TitleInfo.Visible = True
FpSpread1.TitleInfo.Text = "FarPoint Spread Title"
' Show the subtitle for the individual sheet.
FpSpread1.Sheets(0).TitleInfo.Visible = True
FpSpread1.Sheets(0).TitleInfo.Text = "Sheet Only Subtitle"
FpSpread1.Sheets(0).TitleInfo.HorizontalAlign = HorizontalAlign.Center
FpSpread1.Sheets(0).TitleInfo.BackColor = System.Drawing.Color.Aqua
```

## Using the Spread Designer

1. Select the **Settings** menu.
2. Select the **Title** icon under the **Spread Settings** section.
3. Set the title and/or subtitle.
4. Click **Apply and Exit** to close the Spread Designer.