I want to create a custom list and, as I type characters in a specific cell, I want to autoCOMPLETE from the custom list.
A sample workbook is attached.
Thank you.
I want to create a custom list and, as I type characters in a specific cell, I want to autoCOMPLETE from the custom list.
A sample workbook is attached.
Thank you.
Last edited by dvess11; 02-25-2023 at 07:06 PM. Reason: Misleading title
As you have the 365 version, this video may be helpful: https://www.youtube.com/watch?v=nEQeAE860ag
I hope that you have a blessed day.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thanks for the link JeteMc. At 4:05 of the video, it shows "I press the letter A and it looks inside my data validation list and finds Accounting". My Excel doesn't show this little drop down box. Is there possibly something I have toggled to "off" in the Excel options that prevents this from occurring?
1. That feature will be rolled out to MS365 users - it's not available yet (it may be to "insiders").
2. That feature IS available in OneDrive online. So if you save your file to Onedrive, then access that file on-line and view it in your browser, it's available now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks