# Spread Settings Dialog

Discover how to optimize the entire spreadsheet component using Spread Settings dialog. Learn to customize editing, scroll bars, general features, split boxes, view settings, and titles.

## Content

You can set several properties of the entire spreadsheet component using the **Spread Settings** dialog of the Spread Designer. To open this dialog, from the **Settings** menu, select an option under the **Spread Settings** section. 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. An example of the dialog is shown here.
![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.de613e.png?width=800)
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.
This dialog has the following tabs:

| **Tab** | **Description** |
| --- | ----------- |
| [Edit Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabedit) | Change certain aspects of editing cells. Options to change include: Editing Text Can Overflow, Cells Always in Edit Mode, Editing Replaces Existing Text, and On Focus Set Cell to Pointer. |
| [Scroll Bars Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabscroll) | Set the alignment and display of scroll bars: Align at Last Row and Column, Scroll Box Reflects Maximum Rows, Horizontal Scroll Bar Display |
| [General Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabgenrl) | Set options for controlling multiple features of the spreadsheet, such as the ability to drag an drop or drag and fill a range of cells. |
| [Split Box Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabsplit) | Set the alignment and display of split boxes: Column Split Box Alignment, Column Split Box Display, Row Split Box Alignment, Row Split Box Display. |
| [View Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabview) | Set various settings relating to the view: Cell Contents Can Overflow, Display Note Indicator, Retain Selected Block, Cell Buttons Display, Block Mode. |
| [Calculations Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabcalculations) | Set the properties related to formula calculation within cells in the sheet. |
| [Titles Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog/spwin-spd-dsset-tabtitles) | Set a Title and SubTitle for the control. |

For more information on the appearance settings of the Spread, refer to [Customizing the Overall Component Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearcontrol) in the Developer’s Guide.
For more details on the individual settings, refer to the properties of the [FpSpread](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.html) class.

## 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 Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog)
[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)
[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)