Clearing Formatting

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

To clear the formatting associated with a form or ad hoc grid, select Clear from the Formatting group on the Planning ribbon.

Selecting the Clear option removes any Excel formatting associated with the form or grid, both within Excel and within the web application. Note that you can still work with cell styles functionality since cell styles are not dependent on any custom formatting that is saved.