logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Transpose data with formulas...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Range  ›  18. 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
1 Before
Example screenshot: 2 The result, all cell references have been preserved
2 The result, all cell references have been preserved

Starting this tool


Range  ›  18 Transpose data with formulas...
Copy and paste multiple selected ranges at once...



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years