To save Excel formatting on a Planning form:
Use native Excel formatting features to apply the formatting to the sheet.
On the Planning ribbon, select Save from the Formatting group.
Go to Viewing Formatting in Smart View to choose a viewing option.
Related Topics:
Viewing Formatting in Smart View
Saving Excel Formatting From an Ad Hoc Grid
Supported Native Excel Formatting
Guidelines for Working with Native Excel Formatting and Planning Forms