top of page

Create and Learn Books - a quick and easy way to learn by doing

Search
  • Writer's pictureCreate and Learn
    • Nov 8, 2020

Excel Tips - Paste Special to Transpose



You've got a bunch of rows, and you want them to be columns.

Or vice versa...

1- Copy that data, select Paste Special, check the Transpose box, and click OK to paste into a different orientation.

2- Columns become rows, rows become columns!