> 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](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaPuo2ZA8YLAvi0CR_G%2F-LaPyHhIi2CpjD_ePe1s%2Ftext_format.png?alt=media\&token=261b4354-b430-4f90-8b02-4bff3b1267a3)

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](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaPuo2ZA8YLAvi0CR_G%2F-LaQ01SbS8E3OMWRf7Xa%2Ftext_align.png?alt=media\&token=45a54a28-8862-47b1-87d4-a94c4a03868e)

## 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](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaQ38eTRUBN74EFLFuU%2F-LaQ6594dI_GzuV0sKV-%2Fclear_button.png?alt=media\&token=7df515a0-2376-4681-882d-510262ebccac)

    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.

![](https://849025270-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LP_ft7DF7Cv1-qfbadp%2F-LaQ38eTRUBN74EFLFuU%2F-LaQ9W5bXQAvfPqXSAAH%2Fclear_menu.png?alt=media\&token=dded2c25-2464-43b4-9c1a-14761cffd63c)