Menu
For Excel 2010, when I have the filter drop-down open
...how do I get to the filter checkbox section via keyboard shortcut? Skipping everything from "Sort A to Z" to the "Search" box, going all the way to the checkboxes.
514
We must first select a cell in the header row. As we can see, every cell contains a drop-down icon like the image. Then, press the “ALT + down arrow key” on the keyboard to open the “Filter” menu like the below screenshot.
Select a cell in the header row. You will see that each header has a drop-down icon, press the ALT + Down Arrow key on the keyboard to open the filter menu.
Use Alt + Down Arrow keys (Windows and Linux) or Option + Down Arrow keys (Mac) to open drop-down lists that do not have an Apply or Go button, and then use the Down Arrow, Up Arrow and Enter keys to select an item in the drop-down.
ALT+DOWN arrow key opens the selection box. Use the arrow keys to select an option and SPACEBAR to "check" or "uncheck."
174
In Excel 2010 (English) you just have to press e to get to the filter textbox; from there you can use the down arrow key ↓ to go to the first checkbox:
Shift+Tab
Shift+Tab
Shift+Tab
(as mentioned by @Sean_Cheshire) - this goes "backwards" from the first entry over "Cancel" and "OK" to the first (sic!) checkbox.
The question above is about how to move inside the filter drop-down. 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+ ↓ .
For tables: If you are using a Table object instead of a pivot table or regular filtered range, you can be in any row of the Table and open the filter drop-down using Alt+Shift+ ↓
31
Try ALT+down. It opens the drop down list in filters and cells as well.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
