Use Cell Styles
You format every header by hand — bold, blue, size 14 — and every sheet looks slightly different. Cell Styles are one-click formatting presets: apply Heading 1 and every header matches, forever. Change the style once and every styled cell updates. Consistency without the tedium.
TL;DR / Quick Fix
Quick fix: select a cell and pick a style from the Home tab's Cell Styles gallery. Apply the same style to all similar cells for instant consistency. Right-click a style to modify it; every cell using it updates. Custom styles save to the workbook for reuse.
Follow these steps
- Open the Styles gallery. On the Home tab, find Cell Styles. The gallery shows built-ins: Normal, Good, Bad, Neutral, headings, and more.
- Apply to headers. Select header cells and click Heading 1 or Accent style. Instant professional formatting — no manual bolding.
- Style consistently. Same meaning, same style: all totals get Total, all warnings get Bad. Consistency is the whole point.
- Modify a style once. Right-click a style, Modify, change the font or color. Every cell using that style updates everywhere — the real power.
- Create custom styles. For brand colors, create your own style from a formatted cell. Custom styles live in the workbook.
- Explore the formatting family. Styles pair with color scales, data bars, and icon sets for rich, consistent sheets.
What NOT to do
- Do not format every cell manually. Manual formatting drifts — styles enforce consistency automatically.
- Do not create twenty custom styles. A handful of clear styles beats a rainbow of one-off formats.
- Do not ignore the built-in semantics. Good/Bad/Neutral carry meaning for collaborators — use them as intended.
- Do not forget styles travel with the workbook. Custom styles stay in the file — colleagues get them automatically.
Frequently asked questions
What is the difference between styles and themes?
Styles format individual cells; themes set the workbook's fonts and colors globally. Styles use the theme's palette.
Can I copy styles between workbooks?
Yes — use Merge Styles to import a workbook's styles into another.
Why did my style change unexpectedly?
Someone modified the style definition. Styles are shared — one edit updates every styled cell.