jump to navigation

Delete Named Ranges in Excel 2007 / 2010 August 22, 2011

Posted by computertrainer in Excel Tips, Office 2007 Tips, Office 2010 Tips.
Tags: , , ,

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:

  1. 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).
  2. Click an existing range name and then click the Delete button.  A confirmation message appears, making sure you want to delete the range name.
  3. Click OK to confirmation that the range will be deleted.  Cancel cancels the deletion.
  4. Click the Closebutton to close the Name Manager dialog box.

    Name Manager Dialog Box



No comments yet — be the first.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: