How to remove drop-down list in Google Sheets
If you no longer want a drop-down list in your worksheet, you can remove it. WindowsmacOSWeb
If you need to remove all Data Validation from a worksheet, including drop-down lists, but you don't know where they are, then you can use the Go To Special dialog. Press Ctrl+G > Special, then Data Validation > All or Same, and repeat the steps above. If, instead of deleting it, you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list.
If you need to remove all Data Validation from a worksheet, including drop-down lists, but you don't know where they are, then you can use the Go To Special dialog. Press Ctrl+G > Special, then Data Validation > All or Same, and repeat the steps above. If, instead of deleting it, you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list.
If, instead of deleting the drop-down list, you decide you want to change the options, see Add or remove items from a drop-down list. Need more help?You can always ask an expert in the Excel Tech Communityor get support in the Answers community. See AlsoCreate a drop-down list Apply data validation to cells |