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 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!


About-Launch-ExcelWelcome to Launch Excel
If this is your first time to LaunchExcel.com - Welcome to Launch Excel. My name is Victor and I'm the Chief Teaching Officer of Launch Excel, a website I started to help you learn how to use Microsoft Excel more effectively. Check out my welcome page created specially for you: Click here to view Welcome Page


6 Responses to How to Use the Auto Filter in Microsoft Excel with this Great Keyboard Shortcut
  1. Edith
    October 9, 2011 | 4:13 pm

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

  2. Victoria
    October 9, 2011 | 8:29 pm

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

  3. Alex
    October 12, 2011 | 8:55 pm

    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
      October 13, 2011 | 2:08 pm

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

  4. The Best of Launch Excel articles in 2011
    January 4, 2012 | 4:53 pm

    [...] 6. Autofilter Keyboard Shortcut [...]

  5. sanaan
    December 4, 2012 | 9:57 am

    Thank you