# Formatter and Editor

Learn how to format cell data using the Format Cells dialog in Spread Win Designer. Modify number formatting, alignment, font, border, fill, and set protection effortlessly.

## Content

The **Format Cells** dialog of Spread Designer enables you to format the data displayed in a cell. Using the six tabs available in this dialog, users can modify number formatting, alignment, font, border, fill, and protection.

In order to launch the **Format Cells** dialog from the Spread Designer, follow these steps:

1. Select a cell or a cell range in the worksheet that you wish to format or edit.
2. Right-click on the selected cell or the cell range.
3. Choose the option **Format Cells** from the displayed context menu.
    ![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.9f274a.png)
    You can also use the keyboard shortcut Ctrl +1 to call the Format Cells dialog.
4. The **Format Cells** dialog will appear on the screen.

![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.a379d2.png?width=700)
Using the **Number** tab of Format Cells dialog, you can format the values in cell as fractions, currency, percentages, decimals, scientific data, date, time etc. Selecting the **Custom** category enables you to create custom code formats based on the available code formats.
To know more about cell formats in Spread for WinForms, refer to [Working with Cell Format Strings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-format).