Wauvel

Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← 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.

Get my free report →