Ask Your Question
6

How to move columns/rows in Calc?

asked 2014-04-27 09:14:20 +0100

Bulwersator gravatar image

I want to move entire column/row. I remember that it was possible in Excel with simple drag & drop but it is not working in Calc 4.2.2.1.

I tried tragging while holding ctrl, alt, alt+ctrl, shift+alt ( http://ask.libreoffice.org/en/questio... )

click + drag, with alt pressed after dragging started ( http://en.libreofficeforum.org/node/6704 )

Nothing of this works as expected, either nothing happens or columns/rows are just marked.

edit retag flag offensive close merge delete

5 Answers

Sort by » oldest newest most voted
2

answered 2014-04-27 09:15:23 +0100

Bulwersator gravatar image

It is necessary to drag not by column/row index but by one of cells. I found solution at https://forum.openoffice.org/en/forum...

edit flag offensive delete link more

Comments

1

Yeah, it's a bit of a hidden feature, and I couldn't find anything searching the help for 'calc move column'.

So to move columns or rows, click on the header(s) to select them, then hold down Alt and drag one of the cells in the region to the new location. To make a copy hold down Alt+Ctrl. To just obliterate the destination don't hold down any keys.

bburns gravatar imagebburns ( 2014-11-05 06:43:07 +0100 )edit

@bburns, in Ubuntu Unity 14.04 only the copy (Alt + Ctrl) works for me. If I hold alt Unity just drags the window around instead!

iainelder gravatar imageiainelder ( 2015-01-12 03:11:03 +0100 )edit
1

If you hold down the alt key and try to move the column/row/cell, it won't work. Its important to press the mouse button first and then press the alt key.

francorop gravatar imagefrancorop ( 2015-02-27 17:16:26 +0100 )edit

Under OS X, I can't seem to find any modifier keys that results in the original column being removed. It either copies to the new column, or else it creates a new column with the data and leaves behind an empty column.

Michael Fontaine gravatar imageMichael Fontaine ( 2015-03-18 04:33:25 +0100 )edit

Most Linux window managers have the feature of grabbing a window anywhere by holding down Alt (unless you disable it), whcih doesn't work in Windows. That means to drag cells in Libreoffice under Linux, you have normally to use Shift+Alt!

bennypr0fane gravatar imagebennypr0fane ( 2016-05-07 17:37:27 +0100 )edit

Hi

The (windows) procedure in video (English subtitles)

HTH - Regards

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-11-17 09:53:52 +0100 )edit

I am using LibreOffice on Mac and on Linux (Ubuntu) in its recent versions, there I often need to move cells to re-arrange or re-order calculations. The Shift-Alt key toggles the mouse operation to move the cells, but Ubuntu has that combination mapped to shift the language (keyboard). Microsoft Office uses the Shift key to toggle to move (shift) the content of the cells, what is a very logical choice. The shift key is currently mapped, what prevents LO from applying the same? - Please help! thx

Geb gravatar imageGeb ( 2017-12-02 22:45:44 +0100 )edit
1

answered 2015-06-27 10:36:52 +0100

sancho.s gravatar image

Note that, for either complete rows (or columns) or not, the region ready for drag-and-drop has a different background and border color (light blue). In any case, you have to click anywhere inside that area for drag-and-drop.

edit flag offensive delete link more
0

answered 2017-07-16 21:34:42 +0100

Francewhoa gravatar image

updated 2017-07-16 21:54:36 +0100

Here is one more option to move row(s), column(s), or cell(s) with simple drag & drop. Using LibreOffice Calc 5.x.:

1. Select the entire row(s)

To select the entire row(s) click on the Calc numbered columns located on the far left of any sheet.

Note: That column has darker background colors and is filled with automated row numbers.

2. Press and hold ALT key

Note: Cells are moved and shift the cells in the target area to the right or to the bottom. Source cells are emptied, except if you move within the same rows on the same sheet. If you move within the same rows on the same sheet, the cells in the target area shift to the right, and then the whole row shifts to fill the source area.

3. Left click and hold any cell within that section

4. Using the mouse drag and drop the source row(s) to its destination

Note: Notice the dragged selection has a thick black border only on one side. A thick border on the left indicates vertical insertion mode, and a thick border on the left indicates horizontal insertion mode.

5. Release the mouse button

Done you have successfully moved row(s). To move column(s) redo the same steps as above but with column(s).

Source and more options to move columns, or rows, or cell with simple drag & drop at https://help.libreoffice.org/Calc/Mov...

edit flag offensive delete link more
0

answered 2016-10-31 21:53:22 +0100

cosmeticdavid gravatar image

I cannot get this to work using Linux Mint 17.1. First off, using alt + click is a shortcut to moving windows. If one disables this feature, then the functionality still doesn't work. Nothing happens if one holds alt and tries to drag.

edit flag offensive delete link more

Comments

"If you hold down the alt key and try to move the column/row/cell, it won't work. Its important to press the mouse button first and then press the alt key." (from francorop in comment above) ... this works for me w/ Cinnamon 3.2.7

EasyTrieve gravatar imageEasyTrieve ( 2017-08-24 04:44:47 +0100 )edit
0

answered 2017-11-17 04:53:18 +0100

EasyTrieve gravatar image

1) Select the cells you want to move. You can select either a rectangle, or a group of entire rows or columns using the top or left edge selectors, (but if so read step 2 carefully).

2) Next move inside one of the selected cells, and click and hold down. Important: do not click on a top or left edge selector. This click must be inside a seleced cell.

3) Then with the mouse button still down, press the Alt key and drag the mouse.

You may be able to reverse steps 2 and 3 on some systems. On Linux Debian/Cinnamon you must do this in the above order.

I had this working, and then couldn't get it to work, only because it lacked a clear explanation of how to make it work.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2014-04-27 09:14:20 +0100

Seen: 43,312 times

Last updated: Nov 17