» Deleting a Range Name
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
Why it is highly recommended to delete unnecessary/unneeded range Names:Large number 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 of the unwanted Name.
To delete a range Name:
Press Ctrl+F3, select the Name, and then click Delete.
Book Store:
Recommended Books:
- Investing for Dummies, Third Edition
- East of Eden (Oprah's Book Club)
- Accounting for Dummies
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
No comments have been submitted.
