The ASAP Utilities menu in Excel (English)
Transpose data with formulas...
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語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
Example screenshot: 2 The result, all cell references have been preserved
Starting this tool
- Click ASAP Utilities › Range › 18. Transpose data with formulas...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years