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.

Select "Delete Sheet" to remove the current worksheet. Hide a worksheet that you're not sure you want to delete. Switch to the "Home" tab of the Excel ribbon and locate its Cells group.