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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Nils

    excel hiddden rows and colums - one last question

    Nils, Oct 28, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    237
  2. Guest
    Replies:
    1
    Views:
    586
    Bernard Liengme
    Aug 18, 2005
  3. Guest
    Replies:
    1
    Views:
    376
    Dave Peterson
    Oct 20, 2005
  4. Guest

    How do change rows to colums AND columns to rows

    Guest, Dec 29, 2005, in forum: Microsoft Excel Misc
    Replies:
    7
    Views:
    390
    Peo Sjoblom
    Dec 30, 2005
  5. Guest
    Replies:
    1
    Views:
    378
    Guest
    Jan 30, 2006
  6. Guest
    Replies:
    3
    Views:
    632
    Guest
    Aug 28, 2007
  7. karenb

    IS there a way to invert rows?

    karenb, Jan 15, 2010, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    590
    Gord Dibben
    Jan 15, 2010
  8. Terry Pinnell

    How to invert Cols/Rows?

    Terry Pinnell, Jun 20, 2013, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    343
    Terry Pinnell
    Jun 20, 2013
Loading...