logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Transpose data with formulas...

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

Range  ›  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
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

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

Download
Copy and paste multiple selected ranges at once...



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