how do I invert the rows and colums in excel?

Discussion in 'Microsoft Excel Misc' started by Guest, Oct 19, 2005.

  1. Guest

    Guest Guest

    Is there an easy way to invert rows and columns in Excel?
     
    Guest, Oct 19, 2005
    #1
    1. Advertisements

  2. Guest

    Niek Otten Guest

    Look at Edit>Paste Special, Transpose

    --
    Kind regards,

    Niek Otten

    "Aldofabrizi" <> wrote in message
    news:...
    > Is there an easy way to invert rows and columns in Excel?
     
    Niek Otten, Oct 19, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Select the range you wish to 'invert' and copy. Then Edit > Paste Special
    and select the Transpose radio button.

    --Bruce

    "Aldofabrizi" wrote:

    > Is there an easy way to invert rows and columns in Excel?
     
    Guest, Oct 19, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    1
    Views:
    277
    Bernard Liengme
    Aug 18, 2005
  2. Guest
    Replies:
    1
    Views:
    234
    Dave Peterson
    Oct 20, 2005
  3. Guest

    How do change rows to colums AND columns to rows

    Guest, Dec 29, 2005, in forum: Microsoft Excel Misc
    Replies:
    7
    Views:
    237
    Peo Sjoblom
    Dec 30, 2005
  4. Guest
    Replies:
    3
    Views:
    529
    Guest
    Aug 28, 2007
  5. karenb

    IS there a way to invert rows?

    karenb, Jan 15, 2010, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    361
    Gord Dibben
    Jan 15, 2010
Loading...

Share This Page