Delete Named Ranges in Excel 2007 / 2010 August 22, 2011Posted by computertrainer in Excel Tips, Office 2007 Tips, Office 2010 Tips.
Tags: Delete named ranges, delete range names, Excel, Name Manager
If you have created a number of range names in an Excel 2007 worksheet, you might decide that some names are no longer useful.
To delete named ranges Excel 2007/2010:
- On the Formulas Ribbon, click Name Manager in the Defined Names group. The Name Manager dialog box appears (pictured at the bottom of this post).
- Click an existing range name and then click the Delete button. A confirmation message appears, making sure you want to delete the range name.
- Click OK to confirmation that the range will be deleted. Cancel cancels the deletion.
- Click the Closebutton to close the Name Manager dialog box.