Microsoft Excel Functions & Formulas

Use the TRANSPOSE function to copy a range

from vertical to horizontal or vice versa

Sometimes it is very useful to copy a vertical range of cells to a

horizontal range or vice versa. Just copy a range, select a cell

outside the range, and click Paste Special on the Edit menu.

Checkmark the Transpose option and click OK. The copied range

will be shifted by its vertical or horizontal orientation. To use the

same functionality but keep the original references to the copied

range, use the TRANSPOSE function in an array formula. Follow

this tip to transpose the following table below the range A1:G3.

4

To transpose a range and keep original cell references: ...