> For the complete documentation index, see [llms.txt](https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/data-formatting.md).

# Data Formatting

## Color and style

The toolbar of dhtmlxSpreadSheet contains several sections with buttons for modifying the style of data in a cell. 

![Color and style related controls](/files/-LaPyHhIi2CpjD_ePe1s)

What you can do:

* change the color of a text and its background via color picker linked to the **Text color** button
* change the color of text background via color picker linked to the **Background color** button
* apply *Bold*, *Italic* and *Underline* styles to a text

## Alignment

You can use the corresponding toolbar controls to align data in a cell, as needed: along the left/right edges of a cell , or in its center. 

![Alignment related controls](/files/-LaQ01SbS8E3OMWRf7Xa)

## Removing styles and values

To clear styles applied to data in a cell, or values entered into cells, or remove both data and formatting, you can choose one of the two ways:

1. via the toolbar button:

* Choose necessary cell/cells. 
* Use the **Clear** button in the toolbar.
* Choose the desired option in the drop-down list:

![Options of the Clear button](/files/-LaQ6594dI_GzuV0sKV-)

    2\.  via the context menu of a cell:

* Choose necessary cell/cells.
* Right-click the selection to call the context menu.
* Choose the **Clear** option and then select one of the options in the drop-down list.

![](/files/-LaQ9W5bXQAvfPqXSAAH)