You can set properties on an entire sheet of cells and those properties apply to the sheet.
Here is the context menu available to a selected sheet. Right-click on a selected sheet in the designer to bring up this menu.
This context menu has the following items:
| Context Menu Choice | Description and Reference |
|---|---|
| Clear | Removes the contents of all the cells in the selected row but does not affect the header cells. |
| Select All | Allows you to select the entire sheet, all the cells in the data area, or all the cells with data. |
| Lock | You can lock a column of cells so that the user cannot edit them. Remember this applies the lock to the column, not the individual cells. |
| Sheet Settings | Allows you to edit the properties for the entire sheet. For more information, refer to Sheet Settings Dialog. |
| Print Settings | Allows you to edit the printing properties for the entire sheet. For more information, refer to Sheet Print Settings Dialog. |
| SheetSkin Editor | Runs the SheetSkin Editor to allow you to edit the look and feel (skin) of the entire sheet. For more information, refer to SheetSkin Editor. |
| FpSpreadSkin Editor | Runs the FpSheetSkin Editor to allow you to edit the look and feel (skin) of the entire control. For more information, refer to SpreadSkin Editor. |
For information on how to select a sheet, refer to Selecting a Sheet of Cells.
For information on other selectable items, return to Setting Properties in Spread Designer.