# Printing a Spreadsheet

Learn how you can print the data area of a spreadsheet using Spread for ASP.NET.

## Content

You can print the data area of a spreadsheet by clicking **Print** (or the **Print** icon) in the command bar of the component. The appearance of the print button depends on the setting in the command bar and the type of buttons. For more information refer to [Customizing the Command Buttons](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-interaction/spweb-interact-toolbars/spweb-cmdbar-buttons).
At run time, when you click **Print**, the standard print dialog for your machine appears and you can choose various printer settings before clicking OK to print. You can specify page breaks with the column [PageBreak](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Column.PageBreak.html) property or the row [PageBreak](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Row.PageBreak.html) property when printing to the client.
In addition to the print button, there is an [IsPrint](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.IsPrint.html) property. Setting this to true brings up a preview of what is to be printed.

> !type=note
> **Note:** The [ShowColumnHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.PrintInfo.ShowColumnHeader.html) and [ShowRowHeader](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.PrintInfo.ShowRowHeader.html) properties in the [PrintInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.PrintInfo.html) class apply when printing or saving to PDF.

You can also use the client-side [Print](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-Print) method. For more information, refer to the [Client-Side Scripting Reference](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref).

## Using Code

You can set the [FpSpread](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.html) component [IsPrint](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.IsPrint.html) property in code.

## Example

The following code sets the [IsPrint](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.IsPrint.html) property.

```csharp
FpSpread1.IsPrint = true;
```

```vbnet
FpSpread1.IsPrint = True
```

## Using the Spread Designer

1. Select the **File** menu.
2. Select **Print**, **SaveToPDF**, or **Print Preview** from the **Print** menu.
3. Click **Apply and Exit** to close the Spread Designer.