The ASAP Utilities menu in Excel (English)
Copy Formulas Without Changing Their Cell References...
ASAP Utilities › Range › 15. 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 › Range › 15. Copy Formulas Without Changing Their Cell References...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
Preserve cell references when copying formulas, Copy formulas with relative, absolute, and mixed references intact, Excel copy formulas as-is, Copy formulas exactly as shown in Excel, Retain original cell references when copying formulas, Copy formulas without adjusting references, Maintain cell references during formula copy, Copy formulas without converting to dollar signs, Copy formulas without relative reference changes
Preserve cell references when copying formulas, Copy formulas with relative, absolute, and mixed references intact, Excel copy formulas as-is, Copy formulas exactly as shown in Excel, Retain original cell references when copying formulas, Copy formulas without adjusting references, Maintain cell references during formula copy, Copy formulas without converting to dollar signs, Copy formulas without relative reference changes
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Freeze Conditional Formatting as Static Formatting in Selected Cells |
©1999-2025 ∙ 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 25 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 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.