# Settings Menu Discover the new Data and Settings menus in Spread.NET version 5. Customize properties of your spreadsheet with ease. ## Content Starting with version 5, the **Format** menu of the designer has been replaced by the **Data and Settings** menus. The **Settings** menu gives you the ability to set properties of an entire spreadsheet, or rows or columns if either is selected, or individual cells or a range of cells. From here you can launch the settings dialog boxes or change the height of rows or width of columns. For information on the dialog boxes, refer to [Spread Designer Dialogs](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs). ![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.33cd25.png?width=850) The **Data** menu allows you to create groups (outline grouping) or sort data. The **Settings** menu options are grouped under **Spread Settings**, **Sheet Settings**, **Appearance Settings**, **Other Settings**, and **Designer Settings**. The options are explained in the table below. | **Settings Options** | **Description** | | ---------------- | ----------- | | **Spread Settings** | | | Spread Settings | When an entire Spread is selected, this allows you to customize properties of the FpSpread component. For more information, refer to [Getting Started Designing](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-intro/spwin-spd-getstart) and [Spread Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog). | | **Sheet Settings** | | | Sheet | When a sheet is selected, this allows you to customize properties of the active sheet. For more information, refer to [Adding and Customizing Sheets](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-moresheets) and [Sheet Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog). | | **Appearance Settings** | | | TabStrip Editor | This allows you to customize the tab strip. For more information, refer to the [TabStrip Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDTabStripEditor) | | Focus Indicator Editor | This allows you to customize the appearance of the focus indicator. For more information, refer to the [Focus Indicator Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDFocusEditor) | | Style Editor | This allows you to customize the style. For more information, refer to the [Named Style Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDNamedStyleEditor) | | Spread Skin Editor | This allows you to create a skin for the Spread control. For more information, refer to the [SpreadSkin Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDSpreadSkinEditor) | | Sheet Skin Editor | This allows you to create a skin for the sheet. For more information, refer to the [SheetSkin Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDSheetSkinEditor) | | Alternating Row Editor | This allows you to set properties for alternating rows (such as backcolor). For more information, refer to the [Alternating Row Collection Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDAlternatingRows) | | **Other Settings** | | | Cells | When a cell or range of cells is selected, this allows you to customize properties of the selected cell or cells. For more information, refer to [Setting Cell Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-setcelltype). | | Columns | When a column or range of columns is selected, this allows you to customize properties of the selected column or columns. For more information, refer to [Setting Column Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-setprops-col). | | Rows | When a row or range of rows is selected, this allows you to customize properties of the selected row or row. For more information, refer to [Setting Row Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-setprops-row). | | GroupInfo | This allows you to create basic formatting for groups. | | Input Map | This allows you to create an input map for the keyboard keys. | | **Designer Settings** | | | Save Split Bars on Apply | With this preference checked, Spread Designer applies the split bars and viewports to the spreadsheet; otherwise, the split bars would just be used while in the Spread Designer and lost upon applying. | | Auto-Launch Designer on New Instance of Spread | With this preference selected, the Spread Designer is automatically launched when a new instance of the Spread component is placed on a Windows Form. | | Allow Designer DragFill | With this preference selected, drag fill works in the designer. | | Show Start-Up Screen | With this preference selected, the start-up screen in Spread Designer is displayed each time Spread Designer is launched. With this option toggled, the Spread Designer does not display that initial screen when launched. | | Show Property Grid | If this preference is not selected, the property grid is not visible. Unchecking this option makes the designer faster. | | Show All Conditional Formatting Options | This option shows the conditional formatting with rules and the previous cell conditional formatting options when a designer file that contains the previous cell conditional formatting is loaded. | ## See Also [File Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-file) [Home Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-edit) [Insert Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-insert) [Page Layout Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-layout) [Data Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-data) [View Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-view) [Help Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-help) [Context Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-context) [Sheet Context Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-copy) [Table Context Menu](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-iface/spwin-spd-menus/spwin-spd-menu-table)