Forum Discussion

Mike Guest's avatar
Mike Guest
Copper Contributor
Oct 10, 2018

Clear All under Data Validation

Does anyone know how to remove the drop downs from a column? I have already tried the Clear All under the Data Validation but the drop down still remains.

I am using Office 365 Excel version 1807.

excel

4 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 10, 2018

    Hi Mike,

     

    Select that column, then go to Data >> Data Tools >> Data Validation

    If a message box pops up as shown in the below screenshot, click No.

     

     

    After that, click Clear All button and then hit OK.

    • Mike Guest's avatar
      Mike Guest
      Copper Contributor
      Mar 31, 2020

      Haytham AmairahThanks, that cleared up the annoying message that keeps popping up. Now I can read/enter data without having to see that.

    • Janet_Carroll's avatar
      Janet_Carroll
      Copper Contributor
      Mar 31, 2020
      Hello. I am having the same problem and had already tried what you suggested. The list itself has cleared but the list on the title cell stubbornly remains. Do you have any suggestions please? Janet
      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Mar 31, 2020

        Janet_Carroll

         

        Hi,

         

        It might be an issue with that cell!

        Could you attach the worksheet you're working on or a sample of it, to find out the problem?

         

        Regards

Resources