# Sheet Settings Dialog

Use Spread.NET to develop front-ends to database applications. It gives access to multiple sheets using many types of cells and predefined sheet styles.

## Content

You can set the sheet (SheetView object) properties using the **Sheet Settings** dialog of the Spread Designer. To open this dialog, from the **Settings** menu, select an option from the **Sheet Settings** area. Each of the tabs in the dialog has a group of settings. To change the setting, simply click in the edit field or select the choice. For more information on the individual settings, refer to the properties of the [SheetView](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.html) class. When finished making changes on all tabs, click **OK**. If you wish to apply the changes from the active tab, click **Apply** and then click on the next tab of settings to review or change.
![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.7a0e23.png?width=700)
This dialog has the following tabs:

| **Tab** | **Description** |
| --- | ----------- |
| [General Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog/SDSheetDialog-General) | Various row and column counts for the sheet and operation mode |
| [Colors Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog/SDSheetDialog-Colors) | Colors for various parts of the sheet |
| [Headers Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog/SDSheetDialog-Headers) | Properties related to the row headers and column headers of the sheet |
| [Grid Lines Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog/SDSheetDialog-GridLines) | Properties related to the grid lines on the sheet |
| [Calculations Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabcalculations) | Properties related to the calculation of formulas in the cells on the sheet |
| [Font Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog/SDSheetDialog-Font) | Fonts for null values or locked or selected cells |

For more information on changing properties in code to change the sheet appearance, refer to [Customizing the Individual Sheet Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearsheet) in the Developer’s Guide.

## See Also

[Cell Type Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog)
[Conditional Formatting Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDconditionalDialog)
[Custom File Options Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCustomFileOptions)
[Go To Cell Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDGoToCell)
[Row Height or Column Width Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDHeightWidth)
[Row or Column Insert or Delete Dialogs](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDInsertDelete)
[Shape Properties Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/sdshapepropsdialog)
[Shape Shadow Properties Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDShapeShadowDialog)
[Sheet Print Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDPrintDialog)
[Sort Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSortDialog)
[Spread Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog)
[Unhide Specific Row or Column Dialogs](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDUnhideDialog)
[Zoom Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDZoomDialog)
[BarCode Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog/SD-celltype-barcode)
[Color Picker Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog/sd-celltype-colorpicker)
[Name Manager Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDNameManager)