# Cell Styles Dialog

Learn how to set specific cell styles in a worksheet using Spread Designer. Apply, remove, and create new styles with ease.

## Content

You can set cell-specific styles in a worksheet using the Spread Designer. The cell styles dialog is located in the Home tab under the Styles ribbon group.
![Spread Designer Cell Styles Dialog](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/spwin-style-dialog-designer.png)

## Adding a Style

You can apply a style in a cell by clicking on a style in the Styles group or clicking on the “More” dropdown arrow in the style gallery to choose from additional style formats.
![Apply cell styles in Spread Designer](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/spwin-styledialog-apply.gif)

## Removing a Style

You can remove an applied style by first selecting the cell which needs to change back to default. Choose the "Normal" style from the styles gallery.
![Remove cell styles in Spread Designer](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/spwin-styledialog-remove.gif)

## Creating a New Style

You can create a new style by choosing the “New Cell Styles” option at the bottom of the style gallery.
The option opens a Style dialog where you can select various style properties. The “Format” button opens the "Format cells" dialog where you can select the formats for the new style.
![Create new style in Spread Designer](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sdcellstyles-newstyle.gif)

## Style Context Menu

You can perform additional operations on a style by accessing its context menu. When you right-click on a cell style, the context menu displays the following items to choose from.

* **Apply:** Choose to apply the style on the selected cell.
* **Modify:** Choose to modify the selected style. The style dialog is shown where formatting properties can be chosen as well as the format can be modified.
* **Duplicate:** Choose to create a duplicate of the selected style. The style dialog is shown where a new style name can be entered as well as any existing formatting property can be modified.
* **Delete:** Choose to delete the selected style. Every style can be deleted except the "Normal" style.

![Cell Style Context Menu Items in Spread Designer](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/spwin-styledialog-contextmenu.png)