Deleting a Range Name

Why it is highly recommended to delete unnecessary range Names:

Large numbers of range Names makes it more difficult to locate a specific Name.

Range Names create references and unwanted links.

To find unnecessary/unwanted range Names:

1. Select a cell in a new sheet.

2. Press <F3> and click Paste List. A full list of range names and their

references is pasted into the new sheet; delete each unwanted Name.

To delete a range Name:

Press <Ctrl+F3>, select the Name, and then click Delete.

Tweet