Is there any convenient way to swap two rows in gnumeric? Currently I'm doing it the hard way: insert an empty row, move rows, and remove empty row. I hope that there is a better way...

  • Which operating system and what version of gnumeric?
    – harrymc
    Jul 12 '14 at 11:30
  • @harrymc I don't know about the OP, I'm running xubuntu 14.04 64 bit, gnumeric version 1.12.9
    – Lynob
    Jul 13 '14 at 7:14
  • Select both rows (using the Shift key or by dragging the mouse - don't use the Ctrl key)
  • Copy
  • Right-click → Paste Special
  • In Region operation, choose Flip Vertically

Swapping 2 rows in Gnumeric

  • how to properly select rows? i.imgur.com/h98CK3c.png
    – Lynob
    Jul 13 '14 at 7:42
  • 1
    @Fischer, I pressed Shift then clicked on the row numbers. Jul 13 '14 at 15:46
  • @Fischer, I forgot to mention that I have gnumeric-1.12.17-1.fc20.x86_64 (Fedora 20). Jul 13 '14 at 16:15
  • Yes, to select the full rows you have to click on the row numbers (on the left), and not on the cells. ṧнʊß's animation accurately reflects it (remember you have to click on the shift key if you click on the rows, as he did). Jul 13 '14 at 18:08
  • I saw now your screenshot. You likely pressed the ctrl key, which makes multiple ranges, instead of the shift key, which extends a single range. I'll edit the answer accordingly. Jul 13 '14 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.