From the course: Excel: Filtering Data for Beginners
Join today to access over 22,600 courses taught by industry experts.
Shortcut keys for filtering - Microsoft Excel Tutorial
From the course: Excel: Filtering Data for Beginners
Shortcut keys for filtering
- [Instructor] Let's go over something fun and that's keyboard shortcuts for filters. First off, if you want to make a table of your Excel data you just click anywhere in the data and then press CTRL + T and that will bring up that Create Table dialog box and then you can press Enter and that will create your table. Now you see you've got some filter buttons here at the top, which are handy, but let's say for some reason, they weren't on. Maybe someone did this and turned them off. If you wanted to use your keyboard to bring those filter menus back you could go ahead and press CTRL + shift + L and those filter buttons will appear in your top row. If you arrow over to a cell that has a filter button, you can then press ALT + down arrow and that will bring up the filter menu. If you're on the MAC you can press Option + down arrow and you can arrow down to the check boxes, for example, and if you press spacebar on Select All it will, of course, not select all the others and, for example,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.