Skip to main content

Worksheet Formatting

Worksheet formatting allows you to control how data is displayed, improving readability and making key values stand out. You can format individual columns or groups, or apply rules to highlight specific values—presenting your data clearly and effectively.

Several formatting options are available:

SectionDescription
Column FormattingSet number formats, alignment, font style, and color for column values.
Column Formatting PrioritySpecify which format takes precedence when more than one applies to the same column.
Column Conditional FormattingApply formatting to cells based on conditions—such as outliers or threshold values.
Group FormattingFormat group levels to make them distinct from detail rows.
Group Formatting PriorityControl which group-level format is applied when multiple rules exist.
Group Conditional FormattingUse rules to highlight patterns or trends in aggregated group data.