#How to do filter in excel shortcut keys how to
#How to do filter in excel shortcut keys Pc
#How to do filter in excel shortcut keys series

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.

#How to do filter in excel shortcut keys 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 do filter in excel shortcut keys Pc

Thanks for reading CFI’s guide to Excel shortcuts for your PC and Mac keyboard! By taking the time to learn and master these keys, you’ll significantly speed up your financial analysis.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) If you want to learn these keyboard shortcuts with your own personal online instructor, check out CFI’s Free Excel Crash Course! You’ll receive step by step instructions and demonstrations on how to avoid the mouse and only use your keyboard. Excel is quite robust, meaning there are a lot of different tools that can be utilized within it, and therefore there are many skills one can practice and hone. You may also want to check out our section on Excel formulas or the Excel formulas cheat sheet. If you follow our tips and tricks below you’ll be able to master these shortcuts on Windows or Mac operating systems. Your mouse will be taken away and you’ll be expected to learn financial modeling with only keyboard shortcuts.

#How to do filter in excel shortcut keys series

The first thing you’ll do if you’re hired as an investment banking analyst is take a series of intense Excel training courses. These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more. To be more productive, faster, and more efficient when building financial models or performing financial analysis, it’s important to know the main keyboard shortcuts in Excel.