If you arrow over to a cell that has a filter button, you can then press ALT + down arrow and that will bring up the filter menu. If you wanted to use your keyboard to bring those filter menus back you could go ahead and press CTRL + shift + L and those filter buttons will appear in your top row. Maybe someone did this and turned them off. Now you see you've got some filter buttons here at the top, which are handy, but let's say for some reason, they weren't on. Turn filters on/off, search menu, clear filters, and more. First off, if you want to make a table of your Excel data you just click anywhere in the data and then press CTRL + T and that will bring up that Create Table dialog box and then you can press Enter and that will create your table. Learn keyboard shortcuts for Excel Filter drop down menus to quickly sort and filter your data.
Here we discuss the working of Excel Keyboard Shortcuts, how to access them and how to use Excel Keyboard Shortcuts to save your time.- Let's go over something fun and that's keyboard shortcuts for filters. This is a guide to Excel Keyboard Shortcuts. For tables: If you are using a Table object instead of a pivot table or regular. Initially I had an issue with this shortcut because I use Snag-it for screen capture (the above images were all done via Snag. Use Shift + F10 E F to filter by the selected cell’s Font colour. Use Shift + F10 E C to filter by the selected cell’s Fill colour. Move to the edge of the current data region in a worksheet. To open the filter drop-down, you have one or two options: For any filter: As Juhi and Josh have pointed out, you can open said menu with the keyboard when the column heading cell (where you would click to open the drop-down) is selected by typing Alt +. You can also filter by the cell Fill colour or Font colour. Move one screen to the left in a worksheet. Move one screen to the right in a worksheet. 7 Clear All Filters.Alt+A+C is the keyboard shortcut. Excel Details: 7 Keyboard Shortcuts for the Filter Drop Down Menus in Excel Details: This would be the same as pressing the (Select All) checkbox in the item list.The next shortcut will explain how to clear all the filters in all columns. Scroll through the list or use the Index to quickly go to the section you want. Excel Details: Shortcut To Clear Filters Excel. Move to the previous sheet in a workbook. Below is a huge list of Excel keyboard shortcuts you can use to work faster. Excel Keyboard Shortcuts also helps out or reduces the usage of the mouse & and its number of clicks.Īpart from these, the most commonly used shortcut keys are: In his Video you will see the excel shortcuts to manage Filters.Excel Keyboard Shortcuts helps you to provide an easier and usually quicker method of directing and finishing commands.Things to Remember About Excel Keyboard Shortcuts It Activates the Microsoft Script Editor window.Ĩ. ALT + Letter Keys Shortcut Shortcut Keyĭisplays the Remove Duplicates dialog boxįormat Cells dialog box with the Number tab selected.įormat Cells dialog box with the Font tab selected.įormat number with a thousand’s comma (,) separatorĮxpand the Insert Form Controls and ActiveX Controls drop-down menuĪdd or Remove the vertical interior border. It Displays the drop-down menu for the corresponding smart tag. Inserts a new worksheet into the active workbook Insert Chart (It Creates a chart of the data in the current range)ħ. ALT + SHIFT + Function Keys Shortcut Shortcut Key Maximize or restore currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize currently selected workbook window It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. It is also used to switch between absolute/relative refs