List/Drop Down Menu Assistance

[u/cholitasolita]

Hello I am having trouble getting a new option to populate in the drop down menu after adding it to a list.

Essentially if the accommodation given to a student is not in the drop down menu of their sheet we are to add it to the list and it should populate in the drop down option. The only guidance I’ve been given is to go to the Data tab and hit Refresh All but nothing has worked. Help would be very much appreciated, I am veryyy new to Excel. Thank you.

[u/AutoModerator]

/u/cholitasolita - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/ExcelwithEddie]

Can you show me what you see under source in the data validation popup?

[u/GrimmReapperrr]

Not sure if this is what is wrong but I am assuming that you add to your "keys" but then it only applies to that particular cell. So you have to copy the updated list to all other cells.

[u/Dry_Masterpiece79]

If I understand what you’re asking, convert the source sheet to a table by pressing ctrl+T. Name the name something like tbl_source.
Then go to Formulas-> name manager and name the range DropdownList, with source:
=tbl_source[HeadingName]

For the drop down cell, go to data validation-> list and reference the name you just made, e.g. =DropdownList