Spreadsheet User Guide
  • Introduction
  • Hot Keys List
  • Work with Cells
  • Work with Rows and Columns
  • Data Formatting
  • Number Formatting
  • Excel Import/Export
Powered by GitBook
On this page
  • Color and style
  • Alignment
  • Removing styles and values

Was this helpful?

Data Formatting

PreviousWork with Rows and ColumnsNextNumber Formatting

Last updated 6 years ago

Was this helpful?

Color and style

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

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.

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:

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.

Color and style related controls
Alignment related controls
Options of the Clear button