Remove all or selected metadata from Excel. The first thing you will want to do is to open a spreadsheet in Microsoft Excel. From there, click on the File tab that is located at the top-left.

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.

Let’s use it to delete all of the beverage records (column E) in the simple data set shown in Figure A. First, select the data range that you’re deleting rows from; in our case that’s E3:E47 ...