Pages

▼

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. C.R.February 17, 2012 at 1:34 PM

    right on, thanks!

    ReplyDelete
    Replies
    1. AnonymousMarch 26, 2022 at 9:37 PM

      This comment has been removed by a blog administrator.

      Delete
  2. JesperJuly 10, 2012 at 5:25 AM

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

    ReplyDelete
  3. AnonymousAugust 9, 2012 at 6:49 AM

    Great, so simple, when you know how!! Thanks

    ReplyDelete
  4. UnknownNovember 6, 2012 at 10:35 AM

    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. AnonymousJanuary 18, 2013 at 4:50 PM

    Too bad they ruined this in the update to 2010

    ReplyDelete
  6. ExamplesMarch 16, 2022 at 6:38 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  7. AnonymousMarch 26, 2022 at 9:36 PM

    This comment has been removed by a blog administrator.

    ReplyDelete

I'd love to hear from you!
-Nick