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

One Response 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.

Leave a Reply