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.
#Excel keyboard shortcut for filter 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. Select/clear the current row This shortcut applies to multi-select scenarios only.Īdd the next/previous row to the selected set This shortcut applies to multi-select scenarios only.Īdd a range of rows to the selected set This shortcut applies to multi-select scenarios only.Ĭreate a new row at the bottom of the gridĮxecute the default action in a grid This shortcut is enabled when focus is on a cell containing a hyperlink and all cells in that column have hyperlinks.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) Move to the next/previous row without selecting This shortcut applies to multi-select scenarios only. Move to the next/previous blade (vertical tab)Įxpand a FastTab (with focus on the FastTab header) Move to the first record (outside a grid)Ĭlose the form discarding any unsaved changesĪlt+Shift+Right arrow / Alt+Shift+Left arrow Move to the previous record (outside a grid) Move to the visible first field on the form Open the Filter pane (or switch focus between the Filter pane and the main form if the Filter pane is already open)Ĭlose the Filter pane (with focus in the Filter pane) Open grid filtering for the current columnĬlose grid filtering for the current column Move to the th FactBox (with focus in the FactBox pane)Įxpand a FactBox (with focus on the FactBox header) Move to the next/previous FactBox (with focus in the FactBox pane)Īlt+Shift+Down arrow / Alt+Shift+Up arrow Open the FactBox pane (or move focus to the FactBox pane if it is already open)Ĭlose the FactBox pane (with focus in the FactBox pane) View refresh information for a count tileĬtrl+Shift+Page down / Ctrl+Shift+Page up Action shortcuts To do thisĮxecute the default button on a form/dialog box Alternatively, you can press Alt+Shift+K to open this dialog box (and press Alt+Shift+K a second time to see all currently available shortcuts for the page). This will open a dialog box showing the shortcuts you can use based on where you are on the page. Simply right-click on a control and select View shortcuts. Users can discover currently available shortcuts directly from the user interface. For example, the shortcut "Alt+M,A" requires the user to first press "Alt+M", release the keys, and then press "A". Some of the shortcuts on this page are key chords, meaning they require two consecutive sets of key combinations (separated by a comma) that need to be independently pressed to trigger the required action.
Keys on other keyboard layouts might not correspond exactly to the keys on a US keyboard. The keyboard shortcuts described here refer to the United States keyboard layout.
0 kommentar(er)
