Excel: Turn a Column into a Row and Vice Versa

Just got a call today from an accountant wondering how to turn a column of data into a row. If you don’t know, you’ll love it…so simple:

  1. Highlight the cells you want to flip the orientation on
  2. Ctrl-C to copy (or copy button…whatever you like)
  3. Click Edit/Paste Special (might have to expand your Edit menu if you don’t see it)
  4. Check the Transpose check box in the bottom right and click OK

You can do multiple columns/rows at the same time as well.

The Paste Special menu is tremendously useful, lots to explore there.

Comments are closed.

Powered by WordPress. Designed by Woo Themes