» Deleting a Range Name
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
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:
- Accounting the Easy Way
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Learn MS Excel 2002 VBA/XML Programming
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
