» Deleting a Name when the Reference containing an Error or an Orphan Name in Excel 2007
CATEGORY - Excel Formula and Function
VERSION - Microsoft Excel 2007
1. Select Formulas -> Name manager.
Or
Press Ctrl+F3.
2. Click Filter -> Names with Errors.
To find orphan/unwanted Names:
1. Select a cell, and select Formulas -> Used in Formulas -> Paste.
Or
Press F3.
2. Click Paste List.
A full list of Names and their references is pasted into the cells.
Find the Names to delete.
Book Store:
Recommended Books:
- The 11 Immutable Laws of Internet Branding
- Finance and Accounting for Nonfinancial Managers
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Positioning: The Battle for Your Mind
- Business Plans For Dummies®
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
