Wauvel

Excel like a finance pro.

← The library

Formatting shortcut

Toggle strikethrough

Ctrl + 5 on Windows, ⌘ + Shift + X on Mac.

OccasionalDifficulty 950 · Capable
Practice · 2 questions →

When to use it

Toggles strikethrough on the selection.

The shape of it

Windows
Ctrl + 5
Mac
⌘ + Shift + X

Worked examples

  • Mark done

    Select completed tasks, Ctrl + 5 → Struck through

    A to-do list.

  • Automatic strikethrough

    Conditional formatting rule =C2="Done" with strikethrough → Automatic

    Better than manual.

  • Undo

    Ctrl + 5 again → Removed

    Toggle.

Worth knowing

  • Conditional formatting makes strikethrough data-driven.
  • Combine with grey font for a "done" look.
  • Mac uses ⌘ + Shift + X.

Where it goes wrong

  • Struck-through numbers still sum.
  • Easy to hit instead of Ctrl + 4 (underline).

Related

Ctrl + 1Ctrl + BCtrl + ICtrl + UCtrl + Shift + $Ctrl + Shift + %

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.