Don't press Shift while typing these characters. For example, typing the letter "F" would display the Text, Number or Date Filters sub-menu. The underlined letters that appear in the menu are the shortcut keys for each command. Once the Filter menu is displayed, you can type underlined letters to select a filter option. Filtering by typing underlined characters Type the letter "C" to clear the filter.Ħ.Select a cell in the header row and press Alt + down arrow to display the Filter menu for the column.Press Ctrl + Shift + L to turn filtering on again. 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. 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. Here you'll find links to most keyboard shortcut articles for apps for Office.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) For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse. Many users find that using an external keyboard with keyboard shortcuts for apps for Office helps them work more efficiently. Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Project Online Desktop Client Visio Plan 2 Visio in Microsoft 365 Visio Plan 1 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Visio Professional 2021 Visio Standard 2021 Office 2021 OneNote 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Visio Professional 2019 Visio Standard 2019 Office 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Visio Professional 2016 Visio Standard 2016 Office 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Access 2013 OneNote 2013 Office 2013 Excel for iPhone Word for iPhone PowerPoint for iPhone Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 OneNote 2010 Office 2010 Excel 2007 Word 2007 PowerPoint 2007 Office 2007 Excel for Android phones Outlook Calendar for Windows 10 Outlook Mail for Windows 10 PowerPoint for Android phones Word for Android phones More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |