Wauvel

Excel like a finance pro.

← All tips & shortcuts

Toggle filters

CtrlShiftLTables & data

Add or remove the filter dropdowns on your header row.

Difficulty

Amateur
Practice file

1What it does

Ctrl + Shift + L adds AutoFilter dropdowns to your header row — or clears them if they're already there. From the dropdowns you can sort, search, and narrow the data without writing a formula.

2The shortcut

CtrlShiftL
  1. 1Click any cell in your data.
  2. 2Press Ctrl + Shift + L to add the filter carets.
  3. 3Click a caret to sort or filter; press the shortcut again to clear every filter.

3Before → after

Press the shortcut to play it on a sample sheet.

or press the keys for real

Before — a plain header row

AccountMonthAmount
RevenueJan80,000
COGSJan32,000

4When you use it

  • Quickly isolate one account, region, or status.
  • Sort a column without selecting the whole range.
  • Clear all filters at once to see the full data again.

Want these moves already done for you? Wauvel's free tools download as branded, formula-driven Excel models — Tables, named ranges, and all.

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.