Learn › Excel › Turn filters on or off

Excel filter shortcut: Ctrl + Shift + L

Add filter arrows to your table, and remove them with the same keys.

← All Excel shortcuts

With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.

WindowsCtrl+Shift+L
Mac⌘+Shift+F

Keys on keyboards of other languages

The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.

English (US)Ctrl+Shift+L
HrvatskiCtrl+Shift+L
DeutschStrg+Umschalt+L
EspañolCtrl+Shift+L
FrançaisCtrl+Shift+L
PortuguêsCtrl+Shift+L
ItalianoCtrl+Shift+L
TürkçeCtrl+Shift+L
Bahasa IndonesiaCtrl+Shift+L
PolskiCtrl+Shift+L

What it does

Ctrl + Shift + L turns the filter on for the table you are in. Small arrows appear on every header, and you can sort the rows or show only the ones you need. Press it again and the arrows disappear, and all rows come back.

When to use it

Use it on any list with headers: orders, contacts, expenses. Click one cell inside the table first, so Excel finds the whole table. Then pick a value in the arrow menu to see only those rows.

How to do it

  1. Click any cell inside your table.
  2. Press Ctrl + Shift + L (on a Mac: Command + Shift + F).
  3. Click an arrow on a header, tick the values you want and press Apply. Press the same keys again to remove the arrows.
Good to know: Your data has to sit in one block: no empty rows or columns in the middle, and a header row on top. If there is a gap, the filter covers only the part around the cell you clicked. A filter hides rows, it does not delete them. To bring everything back but keep the arrows, open the arrow menu and choose Clear Filter from that column.

A quick example

You have an orders table with Order, Region, Product and Amount. Click a cell in the table and press Ctrl + Shift + L. Open the arrow on Region, untick Select All, tick South and press Apply. Only the South orders stay on screen. Press the shortcut again to switch the filter off and see every row.

Filter, Sort and Clear Filter

Ctrl + Shift + L only switches the filter arrows on and off. Sorting is in the same arrow menu (Sort A to Z, Sort Z to A). To remove the filter of one column without switching everything off, open its arrow and choose Clear Filter. The shortcut also works on a plain range, but you get the best result with one header row and no empty rows or columns inside the list.

Not working? Check this

  • Nothing happens: click a cell inside the table first, not outside it, and check that your list has a header row.
  • On a Mac use Command + Shift + F. In some versions Ctrl + Shift + L works too.
  • Some rows are missing: a filter is still active. Look for a funnel icon on a header and clear the filter from that column.
  • The arrows appear on only some columns: the list has an empty column in it. Select the whole range first, then press the shortcut.
  • Nothing happens at all: on Windows, Ctrl + Shift can switch the keyboard language, so Excel never gets the keys. If the language indicator in the taskbar changes when you press them, turn that shortcut off under Settings, Time & language, Typing, Advanced keyboard settings, Input language hot keys (the names can differ a little by Windows version).

Quick answers

What is the shortcut to remove a filter in Excel?

Press Ctrl + Shift + L again. It turns the filter arrows off and shows every row. To clear only one column, open its arrow and choose Clear Filter.

Why is the Excel filter shortcut not working?

Click a cell inside your table first, and make sure the list has a header row and no empty column in the middle. On a Mac use Command + Shift + F. In a browser, click into the sheet and not into the search box.

Can I filter more than one column?

Yes. Open the arrow on another column and pick values. Each filter narrows the rows further, and a funnel icon shows which columns are filtered.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games