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.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.