Flip Rows and Columns in OpenOffice

February 13th, 2008

Tag:

To swap rows and columns

1. select the rows and columns you want to flip
2. copy the selection
3. go to Edit -> Paste Special -> Options and check “Transpose”
4. click on OK

By the way, this also works with Excel.

Enjoy

del.icio.us:Flip Rows and Columns in OpenOffice  digg:Flip Rows and Columns in OpenOffice  blinklist:Flip Rows and Columns in OpenOffice  reddit:Flip Rows and Columns in OpenOffice  fark:Flip Rows and Columns in OpenOffice  blogmarks:Flip Rows and Columns in OpenOffice  Y!:Flip Rows and Columns in OpenOffice

3 Responses to “Flip Rows and Columns in OpenOffice”

  1. Ford Prefect Says:
    February 22nd, 2010 at 6:54 pm

    Thank you for the hint!

    Just a note that it works as described also in gnumeric.

  2. Znorg Says:
    August 23rd, 2011 at 8:13 pm

    Just what I needed, thank you!

  3. G74un3 Says:
    December 17th, 2011 at 4:35 pm

    Thank you very much. Just what I was looking for!

Leave a Reply