Deleting a Range Name: 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 of the unwanted Name.
To delete a range Name:
Press Ctrl F3, select the Name, and then click Delete.
No comments:
Post a Comment