### Step 1: Replace Any Formula With Text

Replace any formula with text in the range which you want to transpose.

### Step 2: Copy And Paste Transpose

Now we can transpose our selection with copy and paste special.

### Step 3: Change The Transpose Range Back To Formula

Now we just need to change the text in the transposed version back to formulas. Now we have a transposed version of the original range and all the formula’s have maintained their original references.