Activate excel short menu6/12/2023 Select Filter menu options using shortcuts Press Alt + down arrow to display the Filter menu for the column.ģ.Select a cell in the header row that contains a Filter arrow.To use a shortcut to display the Filter menu for a column: If you have converted a list to a table, the Filter arrows should automatically appear. You can use the same shortcut to turn the Filter off.ĭown arrows will appear beside field names in the header row as follows: If your data range contains any blank columns or rows, select the entire range of cells first. To turn Filter on using a keyboard shortcut, ensure a cell in the range is selected and then press Ctrl + Shift + L. The following are 10 useful keyboard shortcuts to filter data in Excel. 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 instructor-led virtual classroom or in-person classroom Excel courses > Depending on the filter you apply, you may need to clear one filter before applying another filter. You can create three types of filters or autofilters – by value(s), by criteria or by a format (such as a color). Note that filter options change depending on the type of data in the column – text, numbers, dates or times. You can use keyboard shortcuts to select different filter options from the Filter menus or remove the filters. When you first turn on Filter, arrows appear in the header row for each field with a drop-down menu. You can turn on Filter or AutoFilter in Excel for data sets / lists and tables and easily filter and sort data using a mouse or keyboard shortcuts. How to Filter or AutoFilter Excel Data Quickly using Keyboard Shortcutsīy Avantix Learning Team | Updated April 17, 2023Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019, 2021 and 365 (Windows)
0 Comments
Leave a Reply. |