How to Switch Column and Row Data in MS Excel XP

February 6, 2009 by
Filed under: Excel 
  1. Choose the cells to be switched.
  2. Click Copy from the Edit menu.
  3. Position the cursor in the upper-left cell of the paste area.
  4. Click Paste Special from the Edit menu.
  5. Check the box Transpose option.
  6. Click the OK button.


Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.