Excel 2013 transpose data cells and formulas

[erichymer]

How do I transpose a horizontal reading excel into a vertical reading excel and transpose all of the data and formulas?

[:) Sixthsense :)]

Copy the data>>Place the cursor in blank cell>>Press Alt+E+S (To get the Paste Special Dialog Box)>>Click Transpose>>Press Ok...

But you can't transpose the formula's. It works with the data alone.

I believe, you have to go for VBA approach for transposing both data & formulas