Permanent workbook formatting with Excel

[Former Member]

Hello community,

I am trying to format my workbooks in Excel (mainly text alignment within cells and merging multiple cells into one cell, simple stuff), but the formatting does not stick. The next time I open my workbook, the formatting is gone. How can I make the formatting permanent?

Thanks,

Alfred

[ravikanth_indurthi · Accepted solution]

Hi,

Go to workbook's Analysis mode click on the table-> Uncheck the checkbox 'Apply Formatting'->Save and apply Ur formatting and check the workbook.

Hope this helps...

Rgs,

Ravikanth

[Former Member]

Thanks!

[former_member183777]

SAP uses styles to format different kind of cells such as header cells, key figure cells, characteristic cells etc. If you change the appropriate style settings, then the formatting will stick.

Thanks

Vineet

[Former Member]

Vineet,

Thank you for your response. How do I get to these style settings?