» 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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Microsoft Windows XP Step by Step (With CD-ROM)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Personal Finance for Dummies
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
