SAP Knowledge Base Article - Public

2554438 - How to change cell styles in Analysis Office


You would like to modify cell styles in Analysis Office


SAP Analysis for Microsoft Office

Reproducing the Issue

A style set is a collection of Microsoft Excel cell styles that is applied by Analysis to format the cells of a crosstab. Whenever you insert a new crosstab in a workbook, the styles in the current default style set are used to format the crosstab cells.

With Analysis, the following style sets and their cell styles are installed:

  • SAP Blue (default)
  • SAP Black&White
  • SAP Tradeshow Plus
  • SAP Blue Crystal

By modifying the cell styles of these style sets, you can create your own style sets and share them with other users.


You can refer to the steps in Support Content page and change cell styles.


AO, Analysis Office, Styles, StyleSet, cell styles , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , How To


SAP BusinessObjects Analysis for Microsoft Office 2.5