You can also press Ctrl + Shift + L t turn filtering off which will remove the filters. To clear all filters for all fields in the current filtered range, select a cell in the range and press Alt > A > C.ĭon't press Shift and don't press these keys at the same time as they access the Ribbon. Press the Spacebar to check or uncheck a checkbox.Press the up or down arrow keys to select a command.
Once the Filter menu is displayed, you can use your arrow keys to navigate the menu and use Enter and the Spacebar to select and apply filtering: If your data has been converted to a table, you can press Alt + Shift + down arrow in any cell in the table to display the Filter menu for that column. Press Alt + down arrow to display the Filter menu for the column.Select a cell in the header row that contains a Filter arrow.If you have converted a list to a table, the Filter menus should automatically appear. If your data range contains any blank columns or rows, select the entire range of cells first. 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.
MAC MICROSOFT EXCEL KEYBOARD SHORTCUTS HOW TO
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)
0 kommentar(er)
