# Setting Sheet Properties in Spread Designer

Discover the various methods for setting properties in Spread Designer, including using the Properties window, menus, and context menu.

## Content

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.
![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.5f89bf.png)
This context menu has the following items:

| @cols=1:**Context Menu Choice** | @cols=1:**Description** |
| ------------------- | ----------- |
| @cols=1:@rows=1:Cut | @cols=1:@rows=1:Remove the selection and place it on the Clipboard so you can paste it somewhere else. |
| @cols=1:@rows=1:Copy | @cols=1:@rows=1:Copy the selection and place it on the Clipboard so you can paste it elsewhere. |
| @cols=1:@rows=1:Paste | @cols=1:@rows=1:Insert content from the Clipboard into the selected location. |
| @cols=1:@rows=1:Insert | @cols=1:@rows=1:Insert new cells, rows, or columns into the worksheet. |
| @cols=1:@rows=1:Delete | @cols=1:@rows=1:Permanently remove cells, rows, or columns from the worksheet. |
| @cols=1:@rows=1:Select All | @cols=1:@rows=1:Allows you to select the entire sheet, all the cells in the data area, or all the cells with data. |
| @cols=1:@rows=1:Clear Contents | @cols=1:@rows=1:Removes the contents of all the cells in the selected row but does not affect the header cells. |
| @cols=1:@rows=1:Filter | @cols=1:@rows=1:Display only the rows that meet the criteria you specify. |
| @cols=1:@rows=1:Sort | @cols=1:@rows=1:Arrange the selected data in ascending or descending order. |
| @cols=1:@rows=1:Cell Types | @cols=1:@rows=1:Sets the data type for a cell, such as text, number, date, or custom formats. |
| @cols=1:@rows=1:Format Cells | @cols=1:@rows=1:Opens the Format Cells dialog box to modify cell appearance and content format. |
| @cols=1:@rows=1:Define Name | @cols=1:@rows=1:Assign a name to a cell or a range of cells for easy reference in formulas |
| @cols=1:@rows=1:Link | @cols=1:@rows=1:Create a hyperlink in your worksheet. |

For information on how to select a sheet, refer to [Selecting a Sheet of Cells](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-selectobj/spwin-spd-selsheet).
For information on other selectable items, return to [Setting Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop).

## See Also

[Setting Row Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-setprops-row)
[Setting Column Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-setprops-col)
[Setting Cell Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-setcelltype)
[Setting Table Properties in Spread Designer](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-design/spwin-spd-setprop/spwin-spd-settable)