A style set is a collection of Microsoft Excel cell styles that is applied by Analysis to the entire workbook to format the cells of crosstabs. They are a great method for ensuring all the formatting in your workbook has a consistent look, perhaps conforming to your corporate branding guidelines. There are four style sets that come with Analysis for Office. The SAP style set SAP SAP Blue is used as default.
Whenever you insert a new crosstab in a workbook, the styles in the current default style set are used to format the crosstab cells. You can change the applied style set in your analysis by choosing Styles → Apply Style Set . . . and then choosing from the available styles. Select Set as default if you want the selected style set to be your new default style set.
You can also create and share your own style sets by modifying the cell styles of the preconfigured style sets. You will see the specific cell styles on the standard Excel Home ribbon. Simply right-click the SAP cell you want to change and choose Modify. Make any formatting changes you wish, then back on the Analysis Design ribbon, choose Styles → Save Style Set . . . and name your new style set.
To share a style set with other users, choose Export Style Set . . . or to use another user's style set, choose Import Style Set . . .. You can save a style set to a network drive so that other users can easily access it.