To apply formats

Context

You can apply defined cell styles as format to single cells, rows and columns. You can use and selelct standard Microsoft Excel cell styles, SAP cell styles and user-defined cell styles.

You cannot apply Table Design formats if Pause Refresh is active.

Procedure

Select a cell in the crosstab.
Multiple cells cannot be selected.
Select Format cells in the Format group in the ribbon.
In the Format dialog, select the cell range the new format should be applied to.
For a selected dimension header, you have the following options:
- Dimension Header
  The format will be applied to the selected cell.
- Dimension Header and All Members
  The format will be applied to the selected cell and all members of the dimension.
- All Members
  The format will be applied to all dimension members of the selected cell, but not to the selected dimension header cell.
For a selected dimension member, you have the following options:
- Dimension Member
  The format will be applied to the selected cell. A dimension member in a crosstab can be a member of a dimension or a measure header.
- Member and all Dependants on axis
  The format will be applied to the selected cell and all its members on the same axis.
- All Dependants on the Axis for this Member
  The format will be applied to all dimension members of the selected cell, but not to the selected dimension member cell.
For a selected data cell, you have the following option:
- Data Cell
  The format will be applied to the selected cell.
Select the format that should be applied to the defined cells.
Select OK.

Results

The format is applied to the selected cell range in the crosstab. If a cell is affected by more than one format, the last defined format is visible.

You can change an applied format by selecting the cell and Start of the navigation path Format cells Next navigation step <defined format> Change/Delete End of the navigation path .