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, 2022 in Others by Kithuzzz
• 38,020 points
521 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, 2022 by narikkadan
• 63,720 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, 2022 in Others by narikkadan
• 63,720 points
1,131 views
0 votes
1 answer

Hide contents of drop-down list in Excel with password?

So, 3 versions all relatively similar: Above shown ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,720 points
567 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, 2022 in Others by narikkadan
• 63,720 points
997 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, 2022 in Others by narikkadan
• 63,720 points
5,665 views
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,740 points
1,098 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
3,517 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, 2022 in Others by gaurav
• 23,260 points
821 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, 2022 in Others by Edureka
• 13,690 points
982 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, 2022 in Others by narikkadan
• 63,720 points
605 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, 2022 in Others by narikkadan
• 63,720 points
666 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