Can't delete named range in excel

We define and use names in Excel formulas to easily understand, reference, and maintain data.

For example, we can define a name for a table, a cell range, a constant, or a function. 

Too many defined names in your workbook consume a  lot of working memory and may slow down your workbook.

Therefore, you must delete some defined names to improve the workbook’s performance. 

This tutorial shows three techniques for deleting defined names in Excel. 

Note: If a formula in the workbook uses a defined name you want to delete, ensure that you replace it before deleting it; otherwise, the formula will return an error. 

Method #1: Use the Name Manager Tool

The Name Manager in Excel is a built-in tool that lets us generate, edit, delete and locate all the names used in a workbook. 

We will use the following workbook with three defined names in the Name Box to show how we can use the Name Manager tool to delete a defined name in Excel.

We want to delete the James_Washington_Math_Score defined name because we no longer need it in the wor

how to remove cell range name in excel

how to delete existing table name in excel