Paste Special to Transpose

You are here:
Estimated reading time: < 1 min

You’ve got a bunch of rows. You want them to be columns. Or vice versa. You would go nuts moving things cell by cell. Copy that data, select Paste Special, check the Transpose box, and click OK to paste into a different orientation. Columns become rows, rows become columns.

Paste Special to Transpose

Was this article helpful?
Dislike 0
Previous: Paint Cells to a New Format
Next: Text to Columns