Pinterest Pixel

CTRL + SHIFT + L: Insert a Filter in Excel

CTRL + SHIFT + L: Insert a Filter in Excel To insert a filter in Excel using... read more

John Michaloudis
Posted on

Steps To Follow

Overview

CTRL + SHIFT + L: Insert a Filter in Excel | MyExcelOnline CTRL + SHIFT + L: Insert a Filter in Excel | MyExcelOnline

CTRL + SHIFT + L: Insert a Filter in Excel

To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press CTRL+SHIFT+L

To un-filter, you need to press this shortcut again.  I use this shortcut all the time 🙂728x90

 

If you like this Excel tip, please share it
CTRL + SHIFT + L: Insert a Filter in Excel | MyExcelOnline CTRL + SHIFT + L: Insert a Filter in Excel | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  F4: Excel Repeat Last Action

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...