Cell style options are global options, which apply to the entire current workbook, including any new worksheets added to the current workbook, and to any workbooks and worksheets that are created henceforth. Changes to global option settings become the default for all existing and new Microsoft Office documents.
It is not necessary to use Apply to All Worksheets or Save as Default Options with these options.
On the Cell Styles page, you can specify formatting to indicate certain types of member and data cells. Because cells may belong to more than one type—a member cell can be both parent and child, for example—you can also set the order of precedence for how cell styles are applied.
To specify a style:
Select Properties and specify a font, background color, or border.
Smart View allows the setting of only one style per cell type.
For example, you may set a background style or a font style for Parent members, but you cannot set both a background and font style for Parent members.
To re-order precedence of cell styles, use the Move Up and Move Down buttons or drag and drop the cell styles.
Click OK. The setting takes effect after you refresh or perform a drill operation.
Optional: To revert cell styles or precedence to the default styles of the connected Smart View provider, click Default Styles.
Optional: To set your selections on this page as default settings, click the arrow in the OK button, and then select Save as Default Options.
Table 17. Cell Style Options Supported for Planning Forms and Ad Hoc
| Option | Forms | Ad Hoc |
|---|---|---|
| Member cells | ||
| Members | X | X |
| Formula | X | |
| Data cells | ||
| Locked | X | |
| Supporting details | X | X |
| Read-only | X | X |
| Cell Text | X | X |
| Document Attachment | X | X |
| Writable (lowest priority is recommended) | X | X |
| Drill-through | X | X |
Table 18. Cell Style Options Supported for Financial Management Forms and Ad Hoc
| Option | Forms | Ad Hoc |
|---|---|---|
| Member cells | ||
| Add Member | X | |
| Linked Form | X | |
| Members | X | X |
| Server Calculated | ||
| Client Calculated | ||
| Data cells | ||
| Drill-through | X | X |
| Derived | X | |
| Invalid | X | X |
| Locked | N/A | N/A |
| Impacted | X | X |
| Read-only | X | X |
| Cell text | X | X |
| Writable (lowest priority is recommended) | X | X |
| Server Calculated | ||
| Client Calculated | ||
| Supports Allocation |