Formula and Name Manager for Excel

This edition uses the license management system on UniformSoftware.com. If you prefer to manage licenses using the Microsoft Admin Center, visit this edition. For more information about the differences between the licensing systems, please visit here.

Formula Manager is a powerful app for Excel that gives professional users a comprehensive toolkit for managing defined names, range formulas, and table names. Whether you need to create hundreds of named ranges in seconds, clean up a cluttered workbook, analyze complex formula dependencies, or shift names between local and global scope, Formula Manager handles it all from a dedicated ribbon tab -- no manual workarounds required.

After installation, a Formula Manager tab appears directly in the Excel ribbon, putting every tool within one click. A built-in backup system can automatically save a copy of your workbook before any bulk operation, so your data is always protected.

From maintaining large financial models to enforcing naming conventions across teams, Formula Manager is the essential productivity app for advanced Excel users.

Features:

• Batch name creation — Generate sequentially named ranges in one operation using flexible placeholders (e.g. Region??), with configurable start numbers, scope, and comments
• Batch delete — Filter and delete any combination of defined names, range formulas, and table names from a single unified list
• Batch formula assignment — Apply a formula pattern across multiple selected cells at once, using the same sequence-numbering system as name creation
• Localize names — Convert workbook-level (global) names to worksheet-level (local) names in bulk, with automatic formula reference updates
• Globalize names — Promote worksheet-level names to workbook scope so they are accessible from any sheet
• Explorer — A full-featured browser for every name and formula in your workbook, with multi-criteria filtering, column sorting, and navigation history
• Dependency tracking — See exactly what references each name and what each name depends on, with dedicated "Referred By" and "Refers To" panels
• Extended formula scanning — Detect name references hidden in hyperlinks, data validation rules, conditional formatting, and embedded objects
• Export / Import workflow — Export name definitions to an editable worksheet, modify them directly in Excel, then import changes back in bulk
• Name map export — Generate a complete cross-reference worksheet showing every name alongside all formulas and objects that reference it
• Automatic backups — Back up your workbook before every bulk change, with configurable retention periods
• Flexible ribbon placement — Install Formula Manager as a dedicated ribbon tab or as a drop-down button within Excel's built-in Formulas tab

• The desktop edition of Excel/Office 2016 or later versions, i.e., the downloadable and locally installed Excel/Office. It doesn't work with the web edition of Excel/Office that runs inside web browsers.
• Windows 10 or later versions.
• X86 or X64 systems.