Tip of the Day | Sunday May 10th, 2026
Discover new tools to get things done.
Copy Formulas Without Changing Their Cell References...
This tool copies all formulas and values in your selection exactly as they are, without adjusting the cell references. Normally, when you copy a formula, Excel automatically changes the cell references relative to the new location. With this tool, you can copy your formulas to another location while keeping the original references intact, eliminating the need to manually add dollar signs to change to mixed or absolute referencing (for example, converting A1 to $A$1). In addition to formulas and values, this tool also copies any cell formatting, comments, and data validation settings.Starting this tool
- Click ASAP Utilities › Formulas › 5. Copy Formulas Without Changing Their Cell References...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.