Productive Linux


 Subscribe via Feedburner in a reader

Enter your email address:

Delivered by FeedBurner


Don't have an account?
Sign up to
Forgot your password?

Gnumeric: Change rows into columns
1 November 2010 @ 13:31 GMT
by Paul

Sometimes, the best tool for a job is a Spreadsheet. When I have to use a spreadsheet I prefer Gnumeric to the over-bloated OpenOffice.

Today, I pasted (from a Website) a couple of rows of figures into Gnumeric. However, I didn't want these figures in rows, but in columns. The solution is easy:

  1. Select and copy the relevant rows.
  2. Choose 'Paste Special...' from the 'Edit' menu.
  3. Click the 'Transpose' box and then 'OK'.

    Paste Special Dialogue

Wow! The rows are now columns.

helpful, thanks.

Posted by behzad on 2011-02-02 11:14:44.
Comments disabled