» 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:
- The Guide to Understanding Financial Statements
- Understanding Financial Statements
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Advanced modelling in finance using Excel and VBA
No comments have been submitted.
