How to select a value from drop down in a cell of MS Excel with keyboard?
Is there any way to select the value from a drop down list in excel by using only keyboard
Solution 1:
Yup. Press Alt+Down Arrow (+Up Arrow also works). Then you can use the arrow keys (Left Arrow and Right Arrow also work) to move around the selection and then press Enter to select an entry.
Edit: works on autofilters, too.