How to Remove Drop Down Boxes on Excelby Anne Hirsh
Drop-down lists can help you regulate the information people enter into an Excel spreadsheet, but selecting from a list can limit your options. If you have drop-down list boxes that you no longer need, you can easily delete them without deleting the data that is the source of the list, just in case you want to add them back later. Save your spreadsheet before you make any changes so you have a clean copy to return to if you make a mistake.
Click inside the cell that has a drop-down list you want to delete. Do not double-click, as this tells Excel that you are editing rather than selecting the cell. You cannot access the appropriate menu while editing a cell.
Click the "Data" tab on the Office Ribbon and select "Data validation," which is in the "Data tools" area near the right side of the screen.
Select "Settings" from the tabs at the top of the dialog box that opens.
Click "Clear all," and then click "OK." Excel will delete your drop-down list. Repeat the process for each cell with a drop-down selection you want to remove.
- If you have multiple drop-down lists that use the exact same settings, you can delete the drop-downs from all cells at once by selecting "Apply these changes to all other cells with the same settings" before you click "OK."