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

Film clapper from Launch Excel 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)

Download File from Launch Excel 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

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!

Victor Chan
Hi I'm Victor. I started Launch Excel to help you use Excel and VBA faster. Thousands of people have learned new skills and increased their effectiveness at work with our help. You can do it too! Also I've personally used Excel lots since 2002. I use it mainly in accounting and finance but I also have a Masters degree in Engineering from Cambridge University. I hope you enjoy the site and tutorials!
Join over 9,000 subscribers


Recommended Posts
Showing 6 comments
  • Edith

    Thanks for the share! Very useful info, looking to communicate!

  • Victoria

    Digged google 30 mins, finally i get it, thanks!

  • Alex

    After study a few of the blog posts on your website now, and I truly like your way of blogging.

    I bookmarked it to my bookmark website list and will be checking back soon.

    Best regards Alex

    • excelgenius

      Edith, Victoria and Alex
      Thanks for your comments! I hope to provide as much value as I can. If you want you can subscribe to my e-mail newsletter, use the sign-up form on the top/right of every page.

  • sanaan

    Thank you

pingbacks / trackbacks

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Us

Please send us an email and we'll get back to you, asap.

Not readable? Change text.