# 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)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://dhtmlx-docs.gitbook.io/spreadsheet-user-guide/data-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.