Excel: Turn a Column into a Row and Vice Versa

Posted on Monday, January 29th, 2007. Filed under Microsoft Excel.

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.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • Google
  • Live
Sphere: Related Content



You can now:

Leave A Comment (0). Or, Leave A Trackback. Or, view Comments Feed.

Previous Post: Good to Great: Notes »
Next Post: Definition: nee - indicates a former name »

Related Reading:


Subscribe without commenting


Leave a Reply

Note: Any comments are permitted only because the site owner is letting you post, and any comments will be removed for any reason at the absolute discretion of the site owner.

You must be logged in to post a comment.

Latest Posts: