Easy to Find
Sometimes it is difficult to find the formulas or names that you care about, especially if you have a large workbook that contains hundreds of formulas.
Now it is easy to filter all the available formulas and names with various criteria, for example, type, scope, or keywords.
There are also extended properties for filtering and finding items, such as visibility, referring to external resource, with relative references, unused name, etc.
Easy to Update
Besides Add, Edit, and Delete, now you can even convert a local name (scoped to a worksheet) to a global name (scoped to the workbook), or vice versa.
To update many formulas or names in a batch, you can even export all the related names or formulas, modify the exported list, and then import the whole list.
Easy to Analyze
The relationship between the cells, names, and formulas could be complex, but understanding it is critical before you can update, optimize the formulas, or fix problems.
Formula Manager scans the workbook comprehensively and thoroughly and shows you the referring relationships that you can easily navigate.
Easy to Export/Import
Export the formula and name list to a worksheet with a few mouse clicks. You can then analyze or update the exported list.
To update the workbook file with formulas from the exported list, use the "Import" command.
Useful Resources
The following third-party and external resources help you understand and use Excel names and formulas:
- Microsoft: Use the Name Manager in Excel
Official document. A basic introduction to Excel’s built-in Name Manager.
- Spreadsheetweb.com: Excel Named Ranges
Use cases, a downloadable sample workbook, useful tips.
- Stackoverflow.com: How to change Named Range Scope
Traditionally, changing the scope of a defined name is not as easy as it should be, even if you use VBA.
- ExcelJet: 500 Excel Formula Examples
A clean and easy-to-use collection of Excel formulas.
