Forum Discussion

ondylvnv's avatar
ondylvnv
Copper Contributor
Nov 13, 2023

Delete drop down list

How do I delete a drop down list in Excel?  I am working in Excel 2016
excel
BradOBrian40's avatar
BradOBrian40
Copper Contributor
Jun 17, 2024
I have a similar problem getting rid of a drop-down list. I am running MS365 in Windows. The list lays on top of some cells in a spreadsheet, and I can't move it or delete it; it contains the entries "Annual", "Semi-Annual", and "Monthly". I don't know how this box was inserted on my sheet, and it apparently has no functional purpose in changing cell values. I tried the "Data Validation" suggestion above, but that option is grayed-out. Any other solution thoughts?
  • BradOBrian40's avatar
    BradOBrian40
    Copper Contributor
    Jun 17, 2024
    If you mean something like Norton or McAfee, the answer is yes. Thank you.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 18, 2024

      BradOBrian40 

      I mean workbook/worksheet/range protection within Excel workbook

      • BradOBrian40's avatar
        BradOBrian40
        Copper Contributor
        Jul 03, 2024
        Hi Sergei. I am sorry for my delayed response. No, I do not have Sheet or Workbook Protection enabled. It is a multi-sheet (15) Workbook, and this drop-down box appears on only 1 sheet. Thank you.

Resources