Setting Up Cell Styles

To apply a cell style:

1. Select cell style in the drop-down menu of the Cell Styles button in the Table Style group on the Home ribbon tab.

2. Click the style template with the main mouse button or select the Apply item in the style's context menu.

The selected style is applied to cells.

To create a cell style:

1. Select sheet cell, which formatting will be saved as a cell style.

NOTE. If several cells are selected, a style is created where only identical formatting elements will be contained. For example, if cells have different font parameters, but identical fill type, the created style contains this fill type, while font options are not included into the style.

2. Click the Cell Styles button on the Home ribbon tab.

3. Select the Create New Style drop-down menu item.

4. In the dialog box that opens enter the name of created style and click the OK button.

The created style is added to the document style group.

Working with cell style is available in the style's context menu in the drop-down list of the Cell Styles button on the Home ribbon tab.

The following actions are available:

• Edit style. The formatting dialog box opens for a style.

• Rename style.

• Delete style.

To export cell style to external styles:

1. Go to the Home ribbon tab.

2. Select the style template by using the Cell Styles button. Then:

• Click the button and select the Export to External Styles item.

• Select the Export to External Styles item in the style's context menu.

3. In the dialog box that opens select styles table.

The selected style is exported to the specified styles table.

If identifier of the exported style matches the identifier of the style from the styles table, it is prompted to select the action.

Select the action with style:

• Keep Both. The exported style is added to the styles table with a new unique identifier.

• Replace. The style in the current styles table is replaced with the exported one.

• Skip. The style is not exported to the styles table.

• Cancel. Export operation is cancelled.

To connect styles table to the report, select the Connect External Styles Table item in the drop-down menu of the Cell Styles button on the Home ribbon tab. In the dialog box that opens select styles table from repository.

To disconnect styles table, select the Disable External Styles item. Before it is disabled, the user is prompted to copy the styles in use to document styles.

NOTE. Connecting and disconnecting of styles table is available only in the desktop application.