Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
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 –  Fischer Jul 13 '14 at 7:14

1 Answer 1

up vote 5 down vote accepted
+50
  • 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

share|improve this answer
    
how to properly select rows? i.imgur.com/h98CK3c.png –  Fischer Jul 13 '14 at 7:42
1  
@Fischer, I pressed Shift then clicked on the row numbers. –  Cristian Ciupitu Jul 13 '14 at 15:46
    
@Fischer, I forgot to mention that I have gnumeric-1.12.17-1.fc20.x86_64 (Fedora 20). –  Cristian Ciupitu 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). –  Valmiky Arquissandas 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. –  Valmiky Arquissandas Jul 13 '14 at 18:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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