Transpose data with formulas...

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

Formulas › Transpose data with formulas...

This utility will transpose your data and preserves the cell references.
Unlike the standard Excel methods 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

In the Excel menu choose: ASAP Utilities › Formulas › Transpose data with formulas...

Custom formula error message...

Copy formulas without changing their cell references...

Download