Menu
I'd like to be able to select two cells in LibreOffice Calc, and press a magic key of some kind, with the result that the content of the two cells are exchanged.
How do I do that?
I found this solution for Excel, but it doesn't work in LibreOffice: https://superuser.com/questions/257516/swap-cell-contents-in-excel
Thanks Jesper.
603
You can also use a shortcut to swap two numbers in Excel. First, select the cells containing the numbers you want to swap. Then, press and hold down the "Ctrl" key on your keyboard. While holding down the "Ctrl" key, press the "X" key.
Re: Swap two columnsClick anywhere in the highlighted area and drag the column. The mouse pointer should change to show the drag operation. Before you release the mouse button, also press the Alt key. When the mouse pointer is at the left side of column A, release the mouse button.
I realize this question was posted some time ago, but now, as of at least LibreOffice 4.2, you can achieve this via Alt+drag. I was looking for this solution today, and after seeing @wolfQueen's answer, I tried random key combos until I discovered this.
Depending on your system, this may be a bound action. In my OS and desktop environment (Ubuntu 16.04, XFCE) Alt+drag is a window move action, so I have to start dragging the cell, then press Alt to prevent the window manager from stealing the show.
Hope this helps anyone with this same question!
86
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
