SEARCHABLE 🔎 Dropdowns in Excel #shorts

Finally we get SEARCHABLE drop down lists in Microsoft Excel WITHOUT writing complex formulas. There's no VBA, no filter function. The autocomplete functionality is there by default. The ability to search for values in data validation was released on the web (online) version of Excel last year but now it's available in the Excel desktop version as well. To search the drop-down list you just have to start typing in the cell. A list of search results will appear and filtered down as you type. It also automatically suppresses empty cells.

You can use this to create multiple searchable drop-down lists or data validations in a single sheet.

Availability: This update is currently available on the Beta Channel for Office 365 Insiders for Windows and Mac.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

[andrewcharlesmoss]

So glad this feature has finally been implemented! We did have to wait a rather long time though.

[KenBraverman]

That's fantastic, without an addon and that function simply becoming part of a validation list is definitely the way to go

[romulusmilea]

Another great video ! It would be useful to know which Excel version/build contains this new feature. I mean File menu - Account - About Excel - there we can find version and build information.

[Allinused]

If you use your listname you dont have to take a couple of extra rows in your range. It will be dynamic.

[gvinodnair]

Wow! the long-awaited feature is here. 😍😍

[michaelkuhn]

Finally!!! This was such a drawback, thanks for posting.

[MrLexhoya]

I can remember your lesson about the workaround with the lunch and deserts...

[chh]

" ... Did you hear that Excel finally has ..."

Yes, I did ... from Prof Leila ... my Go-To source for anything Excel ... 😉

[curtoliver]

Thanks Leila. I’ve been waiting patiently for this to come out. It’s going to make list so much easier

[albertrondon]

Why are these features not in my O365? I updated my O365 to Version 2203 Build 16.0.15028.20218
but this update was not in it.

[smb]

That's a great info! Thanks a lot

[BAP-Bhaarath-Amaraavathi-P]

Hi, Mam your videos are very educative & impressive. ISBI

[brbball]

TY Leila. Question: Why did you not use a table for the list?

[MyMrwrestling]

when will it be released?? im on 365 and its not been updated

[Nadege]

Why leaving blank lines ? I formate my list as table, that way it's always dynamic...

[petr]

I'm sorry, but you're wrong, Leila. The tool is still not available in some Beta versions of Insider! I have version 2206 (Czech, Beta Channel Insider). Switching to English (environment language, spelling) will not help either. I also left the forum on this topic. They make a fool of us.

[erifirman]

I have 365 insider, but still not show the dropdown list like you told, any advice please

[The_Ol_Bizzaroo]

YES! Is there anyway to force the update if my 365 hasn't updated yet?

[DinoDelight]

Nope, still not here (uk), do we know when vstack is coming?

[calilthomas]

Not available on my excel 365 in the just updated version...