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.
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.
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 video tutorials on our video page.
You will find tips & tricks, shortcuts and spreadsheet case studies. Hope you enjoy!
Victor expertly teaches Microsoft Excel to people all over the world. He has millions of views of his popular Excel explainer videos on YouTube. These show time-saving shortcuts and real-world applications explained with easy-to-follow visuals.
Victor has over 20 years of experience using Excel as a professional for Big 4 Audit Firm Deloitte and two global tech companies. He knows firsthand that being more productive with Excel can lead to greater job satisfaction and career growth.
Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.
Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!
Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.