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

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

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

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.