Cell Styles

Cell style options are global options, which apply to the entire current workbook and to any workbooks and worksheets that are created henceforth.

On the Cell Styles page, you can specify formatting to indicate certain types of member and data cells.

You can specify a style to indicate the type of member and data cells. Because cells may belong to more than one type — a member cell can be both parent and child, for example — you can also set the order of precedence for how cell styles are applied.

  To specify a style:

  1. Expand the list of available cell types.

  2. Select a cell type.

  3. Select Properties and specify a font, background color, or border.

  4. To re-order precedence of cell styles, use the Move Up and Move Down buttons or drag and drop the cell styles.

  5. Click OK. The setting takes effect after you refresh or perform a drill operation.

  6. Optional: To revert cell styles or precedence to the default styles of the connected Smart View provider, click Default Styles.

  7. Optional: To set your selections on this page as default settings, click the arrow in the OK button, and then select Save as Default Options.