Remove Drop Down List In Excel

Steps to remove a drop-down list in Excel

• Step 1: Go to the Data tab and click Data Validation.
• Step 2: In the Data Validation window, switch to the Settings tab, then under Allow, choose Any Value.
• Step 3: Finally, click OK to confirm and apply the change.

Result: The selected cells will no longer be restricted — users can now type any value freely.

Tip: If you don’t see the Data Validation option, make sure the worksheet isn’t protected or locked.