How to Use the Auto Filter in Microsoft Excel with this Great Keyboard Shortcut

Posted September 14, 2011

If you need to sort through, sift or filter many rows of data in Excel it’s useful to know how to apply and clear Excel’s auto-filter feature quickly. We put together a 6 minute video to explain how you can use a handy keyboard shortcut to filter and unfilter data in Excel.

There is also a spreadsheet for you to download so you can follow along with the video. You’ll need Excel 2007 or 2010 for the spreadsheet to work.

Excel Auto Filter and Keyboard Shortcut

The video is best viewed in HD. You can also view it in Youtube by clicking here.

The keyboard shortcut to apply and remove filters is Ctrl + Shift + L. You must first select a cell inside your data table before you press Ctrl + Shift + L, so that Excel knows to apply filters on that table and not somewhere else.

When you have applied more than one filter and want to clear all of the filters at once, it’s very handy to press Ctrl + Shift + L twice, first time to remove all filters and second time to reapply the filters.

Sample Spreadsheet (.xlsx file for Excel 2007 and 2010)

To download the spreadsheet I used in the video, please click on the download link here. The data from the spreadsheet is available freely from the World Bank website at http://data.worldbank.org/indicator/NY.GNP.PCAP.CD.

I use the acronym “GNI” a lot in the video and if you’re interested, here is a brief description from the World Bank “GNI per capita (formerly GNP per capita) is the gross national income, converted to U.S. dollars using the World Bank Atlas method, divided by the midyear population.”

Watch more Excel tutorial videos

Watch more video tutorials on our video page.

You will find tips & tricks, shortcuts and spreadsheet case studies. Hope you enjoy!

Keyboard, Shortcuts

Facebook Twitter Google+Share

Victor Chan

Victor has been using Excel intensively since 2002. He is a Chartered Accountant (Fellow of the ICAEW) and has an MEng in Manufacturing Engineering from the University of Cambridge. He is on a mission to help you learn Excel and VBA with practical video tutorials and awesome online courses.

Join over 9,000 subscribers

GET BETTER AT EXCEL

CLICK TO GET FREE UPDATES