Saving Excel Formatting From an Ad Hoc Grid

  To save formatting from an ad hoc grid:

1. Perform ad hoc analysis to create a grid to save.

2. Use Excel native formatting features to format the grid.

3. From the Planning Ad Hoc ribbon, select Save Ad Hoc Grid.

4. In the Save Grid As dialog box, select the Submit Formatting option when saving the ad hoc grid as a form.

   You can now open the saved form and choose a viewing option as described in Viewing Formatting in Smart View.