Forum Discussion

BrentM500's avatar
BrentM500
Copper Contributor
Mar 12, 2023
Solved

Excel AutoComplete not working with Data Validation Lists even after following all fix suggestions

Hi, I would appreciate help with AutoComplete in Excel.   Problem: - Data Validation List created does not show suggestions when typing valid entries in the dropdown cell - Clicking on the dropd...
excel
Formulas and Functions
office 365
  • JKPieterse's avatar
    JKPieterse
    Mar 13, 2023
    Excel desktop will get those features you are asking for in the near future. Currently, this only works in Excel on-line and on the Insider version of Excel.
Prash_MSFT's avatar
Prash_MSFT
Icon for Microsoft rankMicrosoft
Sep 01, 2023

Update... AutoComplete for dropdown lists feature is now available in Current Channel starting with version 2306 build 16.0.16501.20004 or later!

 

When you see it please try it out! We’d love to hear from you whether this meets your expectations or not. Please send us feedback!

 

thanx,

Prash

  • prakashkp's avatar
    prakashkp
    Copper Contributor
    Dec 10, 2024

    my version -Microsoft® Excel® 2021 MSO (Version 2404 Build 16.0.17531.20152) 64-bit, but not working this feature

  • valawcom's avatar
    valawcom
    Copper Contributor
    Mar 26, 2024

    Prash_MSFT, any update on this? I am running Version 2308 (Build 16731.20600) and autofill for dropdowns is not working. 

    • briannahoo's avatar
      briannahoo
      Copper Contributor
      Apr 05, 2024
      Nothing on my side yet, I am running Version 2403 and still cannot use the autofill for dropdowns.
      • jasonvr's avatar
        jasonvr
        Copper Contributor
        Apr 05, 2024

        briannahoo Are you on a subscription version of Office or a perpetual?  Perpetual won't get this feature even if you have the right version (confirmed by Microsoft in another thread)

  • briannahoo's avatar
    briannahoo
    Copper Contributor
    Dec 14, 2023

    Prash_MSFT I am running Version 2311 (Build 17029.20068) and am still not able to use the autocomplete feature with my data validation lists. Do you have any insight into what I need to do to access this feature? I can use it on my office computer with a different login, I am just not there now to access the version I have there. 

    • jasonvr's avatar
      jasonvr
      Copper Contributor
      Dec 31, 2023

      briannahoo Did you ever get an answer to this?  I've got the same problem (though I'm running Version 2311 Build 17029.20108) and I can't get auto-complete to work.  Are you using Office 365 or do you have a non-subscription based perpetual version?  I've got a perpetual version (Professional Plus 2021) and I'm wondering if that is the problem.

      • muibeta's avatar
        muibeta
        Copper Contributor
        Dec 31, 2023

        As per my post June 23, 2023, following a Microsoft 365 update, autocomplete of lists started working again for me and has worked faultlessly since. I am currently running the desktop version of a Microsoft 365 subscription (that includes Excel version 2312 build 17126.20078) under Windows 11. jasonvr 

Resources