Microsoft Excel: How to Remove a Drop-Down List. Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales.

Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete. Click the "Formulas" tab and click "Name Manager" in the Defined Names group.

Removing hidden metadata information from a Microsoft Excel spreadsheet is not difficult if you follow the steps laid out here.