To turn filtering on or off, ensure a cell in the range is selected and then press Ctrl + Shift + L.ĭown arrows will appear beside field names in the header row as follows: The following are 10 useful keyboard shortcuts for filtering. Recommended article: How to Enter Data in an Excel Filtered List into Visible Cells (2 Ways)ĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > The shortcuts are available in Excel 2010 and later versions but some will also work in 2007. When you first turn on filtering, arrows appear in the header row for each field with a drop-down menu.Īlthough most users will use the mouse to apply and remove filtering, you can also use your keyboard. You can turn on filtering (formerly known as auto filtering) for Microsoft Excel lists and tables and easily filter and sort data using a mouse.

How to Filter Microsoft Excel Data Quickly using Keyboard Shortcutsīy Avantix Learning Team | Updated October 20, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)

Microsoft 2007 excel shortcut keys