Transpose data with formulas...

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Formulas › 4. Transpose data with formulas...

This utility will transpose your data and preserves the cell references.
Unlike the standard Excel method, which changes the cell references when the data shifts, this utility will not change the cell references in 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. Transpose data with formulas...
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

Formulas › 4 Transpose data with formulas...

Custom formula error message...

Copy formulas without changing their cell references...

Download

©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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.