Ask Your Question
4

How to move columns/rows in Calc?

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

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

3 Answers

Sort by » oldest newest most voted
2

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

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 +0200 )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 +0200 )edit

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 +0200 )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 +0200 )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 +0200 )edit
0

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

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 2016-10-31 21:53:22 +0200

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 35,483 times

Last updated: Oct 31 '16