Wauvel

Excel like a finance pro.

← The library

Formatting shortcut

Remove all borders

Ctrl + Shift + _ on Windows, ⌘ + Option + - on Mac.

OccasionalDifficulty 1050 · Capable
Practice · 2 questions →

When to use it

Removes all borders from the selection.

The shape of it

Windows
Ctrl + Shift + _
Mac
⌘ + Option + -

Worked examples

  • Strip borders

    Select the range, Ctrl + Shift + _ → All borders gone

    Clean up.

  • Whole sheet

    Ctrl + A, Ctrl + Shift + _ → Sheet-wide

    Reset a messy sheet.

  • After a paste

    After pasting from the web, Ctrl + Shift + _ → Web table borders removed

    Cleanup after paste.

Worth knowing

  • The _ is on the - key: Ctrl + Shift + -.
  • Turn off gridlines under View for a cleaner look instead of adding borders.
  • Clear Formats removes everything, not just borders.

Where it goes wrong

  • Removes borders you wanted to keep in the selection.
  • Does not affect conditional formatting borders.

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.