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.

Now press Delete to remove it from your spreadsheet. Quick tip: If the pivot table is alone on its own sheet, you can delete the entire sheet from your spreadsheet as well. Right-click the tab at ...

Excel will remove it from the list, and you’re left with a list of 3. Doing so deletes items from the list; it will not delete the value in the sheet. Press Ctrl+A to select the three items in ...