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 January 28, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)
