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.
No comments:
Post a Comment