Forum Discussion
ondylvnv
Nov 13, 2023Copper Contributor
Delete drop down list
How do I delete a drop down list in Excel? I am working in Excel 2016
BradOBrian40
Jun 17, 2024Copper Contributor
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?
SergeiBaklan
Jun 17, 2024Diamond Contributor
Do you have any kind of protection?
- BradOBrian40Jun 17, 2024Copper ContributorIf you mean something like Norton or McAfee, the answer is yes. Thank you.
- SergeiBaklanJun 18, 2024Diamond Contributor
- BradOBrian40Jul 03, 2024Copper ContributorHi 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.