Formatting for Clarity

Number Formats

Select cells → Home → Number group: Currency, Percent, Date, or Ctrl+1 for the full dialog:

#,##0.00     1,234.57
0%       ->  12% (a stored 0.12)
#,##0 k     1k  (compact)
"₹"#,##0      ₹1,500

Formatting changes appearance only - it never changes the underlying value.

Alignment

Home → Alignment for wrap text, merge cells, and indents. Wrap Text lets long sentences fit inside narrow cells.

Conditional Formatting

Home → Conditional Formatting paints cells by rules automatically:

• Highlight cells - greater than, text contains, duplicates.
• Color scales - green-to-red heat map for ranges.
• Data bars - mini bar chart inside each cell.
• Icon sets - arrows/traffic lights on scores.
• Custom formula rule: select the range and use a rule like =$A1>100.

Tables (Ctrl+T)

Convert a range to a Table: Excel adds filter buttons, banded rows and auto-expanding named references like Table1[Amount]. Formulas that reference a column update when rows are added - far safer than fixed ranges.

Key Points

• Formatting never changes values - separate how it looks from what it is.
• Conditional formatting turns raw numbers into readable signals.
• Real Tables make filtering and formulas self-maintaining.