From the course: Excel: Filtering Data for Beginners
Join today to access over 24,700 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. That will bring up the Create Table dialogue box, and then you can press Enter and that will create your table. Now, you see you've got filter boxes by default when you create a table, and that's handy. But let's say someone turned them off by unchecking this option. If you wanted them back on, just press Control + Shift + L and do it twice and you can bring them back. If you move your cursor and select a cell with a filter button, you can open that filter button by pressing Alt + Down Arrow, and then you can press the Down Arrow until you get to the item you want to select. And let's say you want to only show Company C's sales. To unselect select all, you press the Spacebar after you arrow to it, and then you press the arrow button down again until you reach Company C, press Space…
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.