Tip of the Day | Thursday 13 August 2026

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.

Starting this tool

Click ASAP Utilities  ›  Range  ›  18. Copy and Transpose Without Changing Formula References...

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: 1 Before (Here's the English version.)
1 Before
Example screenshot: 2 The result, all cell references have been preserved (Here's the English version.)
2 The result, all cell references have been preserved
Today's Tip

Tip:Alt+P for the previous tool.