![transpose excel shortcut transpose excel shortcut](https://www.exceldemy.com/wp-content/uploads/2021/11/Excel-Paste-Transpose-Shortcut-4.png)
Now we just need to change the text in the transposed version back to formulas. Step 3: Change The Transpose Range Back To Formula Select the All radio button under the Paste options.Select an empty cell where you want the transposed version and paste special. You can either use the Ctrl + Alt + V keyboard shortcut or the Paste button in the Home tab of the ribbon.You can either use the Ctrl + C keyboard shortcut or the Copy button in the Home tab of the ribbon. Highlight and copy the range which you want to transpose.Now we can transpose our selection with copy and paste special. It should say we made 6 replacements as there were 6 formula’s in our range. I like to use # as it’s a character that’s unlikely to appear in any of the formula’s but you can use any text in front of the equal sign as long as it’s not in any of your formulas. This will turn any formula into a text string. In the Find what box type in = and in the Replace with box type in #=.
![transpose excel shortcut transpose excel shortcut](https://www.howtoexcel.org/wp-content/uploads/2021/02/Transpose-Data-Example.png)
Alternatively, you can use the Ctrl + H keyboard shortcut to open the Find and Replace window.
![transpose excel shortcut transpose excel shortcut](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/Excel_transponieren_IT_2.png)