Tip of the Day | Friday December 19th, 2025
Discover new tools to get things done.
Copy and Transpose Without Changing Formula References...
This tool copies and transposes your data while preserving the cell references in your formulas.Unlike Excel's standard transpose function, which adjusts cell references when data is shifted, this tool keeps your formula references intact. It makes it easy to reorganize your data without reworking your formulas.
Screenshots
Example screenshot: 1 Before
Example screenshot: 2 The result, all cell references have been preserved
Starting this tool
- Click ASAP Utilities › Formulas › 4. Copy and Transpose Without Changing Formula 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-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.