Navigate Excel Drop-Down List via Keyboard

0 votes
I've made a list of the employees and given several cells a drop-down menu. I've already found the helpful Alt+Down arrow tip to allow me to enter the drop-down via the keyboard.

However, it doesn't look as though I can use the keyboard to choose an item from the list.

For example, I'd prefer to be able to start typing an employee's name to choose from the list rather than using the mouse to scroll through the employees and choose the right one.
Oct 10 in Others by Kithuzzz
• 20,660 points
53 views

1 answer to this question.

0 votes

You are aware of the auto-complete feature Excel has when a word is previously written in a cell above? This is how you can use that feature: Assume that the names in the drop-down boxes in columns C and D are those of your 100 employees, from which you will be selecting. Add 100 lines beginning at line 1. Enter the names of your employees in columns C and D. Next, cover those lines. Line 101 is now in the top row below the header. Now, auto-complete will start working when you begin typing a name in Column C or D.

If you have the header row "frozen": I found this to create a problem, so I had to unfreeze the top row first. Don't forget to freeze your top row after hiding your lines.

Hiding Lines Path is: Home-> Format-> Hide and Unhide -> Hide Rows.

Do not use Home-> View-> Hide, as this hides the entire window.

answered Oct 10 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Excel Drop down list using Apache POI

To set a default value, just setCellValue("first_item_value"); she ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
33 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
63 views
0 votes
1 answer

How to create a dependent drop down list using [Apache POI]

There is nothing apache poi cannot do, ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
190 views
0 votes
1 answer
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
450 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,209 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
68 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
202 views
0 votes
1 answer

On focus after tabbing of Excel drop down, automatically show list for selection

Put the following code in the Microsoft ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
56 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP