Monday, March 29, 2010

How do I make horizontal rows into vertical rows in Excel Spreadsheet?

To make horizontal rows into vertical columns, highlight the cells you want to change, copy, right click cell you want to move to, select ‘paste special’, click ‘transpose’ box, hit ok. It's that simple!

Join our free email newsletter for more advanced Excel tips to make your life easier! Don't worry, we won't swamp your inbox and you can unsubscribe at any time. We'll even send you some useful Excel templates from time to time. Cheers!
 

8 comments:

  1. Replies
    1. This comment has been removed by a blog administrator.

      Delete
  2. Thanks... solved my problem in first search..!!

    ReplyDelete
  3. Great, so simple, when you know how!! Thanks

    ReplyDelete
  4. How about vice versa my headings are vertical and I want to move them horizontal and the text to go with them;

    Name Jim Rex
    Position and Company Visionary Leader for Rapid Growth
    View View Jim's Profile
    Area Greater San Diego Area
    Industry Health, Wellness and Fitness Industry
    Email jrexjr@san.rr.com

    ReplyDelete
  5. Too bad they ruined this in the update to 2010

    ReplyDelete
  6. This comment has been removed by a blog administrator.

    ReplyDelete
  7. This comment has been removed by a blog administrator.

    ReplyDelete

I'd love to hear from you!
-Nick