Blog / Formatting · 8 min read

Excel Formatting Shortcuts: Bold, Number Formats, and Cells Dialog

Format spreadsheets faster with Ctrl+B, Ctrl+1, percentage and currency shortcuts, and other keys that replace endless ribbon clicks.

Formatting makes data readable for stakeholders. Doing it through the ribbon works, yet formatting shortcuts keep your hands on the keyboard while you polish headers, numbers, and emphasis.

Font style keys

  • Ctrl + B — Bold
  • Ctrl + I — Italic
  • Ctrl + U — Underline
  • Ctrl + 5 — Strikethrough

Use bold for headers and key totals. Italic works for notes. Strikethrough helps mark obsolete items in working lists without deleting them yet.

Format Cells: the power dialog

Ctrl + 1 opens Format Cells — number formats, alignment, font, border, fill, and protection in one place. Learn to reach it without thinking. From there you can set custom formats, wrap text, and apply consistent borders.

A useful habit: select the range first with keyboard selection shortcuts, then press Ctrl + 1. Selection plus formatting as one flow is faster than click-drag-click through menus.

Number format shortcuts

  • Ctrl + Shift + $ — Currency format
  • Ctrl + Shift + % — Percentage format
  • Ctrl + Shift + ! — Number with thousand separators and two decimals
  • Ctrl + Shift + ~ — General format

Financial and KPI sheets lean heavily on currency and percent formats. Applying them from the keyboard keeps review sessions moving when you are checking dozens of columns.

Formatting workflow example

Suppose you receive a raw export:

  1. Select the header row with Shift + Space, then bold with Ctrl + B.
  2. Select the amount column and press Ctrl + Shift + $.
  3. Select the margin column and press Ctrl + Shift + %.
  4. Select the full table and open Ctrl + 1 to add a light border if needed.

Practice this sequence in Formatting practice until it feels like one motion. Pair it with our cheat sheet for any format you use less often.

Clean formatting communicates professionalism. Keyboard formatting keeps that polish from slowing you down.

Practice what you learned

Open a free interactive mode and turn these shortcuts into muscle memory.

Related articles