Ask Your Question

Why can't I move a column in Calc without a tedious process? [closed]

asked 2018-02-02 21:00:41 +0200

Mochi gravatar image

updated 2018-02-02 21:27:41 +0200

when building a spreadsheet, im unable to just drag and drop a column or row and just move it. am i missing something, or is there some sort of bug preventing this? this honestly feels like a feature as significant as this would have been added by now.

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by erAck
close date 2018-02-02 22:54:33.668488


Duplicate of question/33207

erAck gravatar imageerAck ( 2018-02-02 22:54:23 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2018-02-02 21:46:36 +0200

ve3oat gravatar image

You don't say what the tedious process was. Did you try a simple copy and paste process? Highlight the row or column you want to move and click on Copy. Then highlight the first cell in the new (intended) row or column and click on Paste. Does that work?

edit flag offensive delete link more


it does, but when doing it several times, it gets tedious. literally every other spreadsheet software has the ability to simply drag it to move it and be able to move on. i might be sounding entitled with this line of thinking, but a workaround like that shouldnt be the only way to do it.

Mochi gravatar imageMochi ( 2018-02-02 22:21:22 +0200 )edit

answered 2018-02-02 22:22:36 +0200

Ratslinger gravatar image

updated 2018-02-02 22:23:52 +0200


You are just missing something. When you want to move an entire column, once selected, left mouse button on any cell in the selected column and while holding the left button drag & drop to new location then hold Alt key when releasing left mouse button.

This & other selections are in the off-line help under columns;moving by drag and drop.

edit flag offensive delete link more

answered 2018-02-02 22:45:02 +0200

erAck gravatar image

updated 2018-02-02 22:53:24 +0200

It was possible with pressing Alt when dropping the column. But then window managers took over and swallowed the Alt key to be used solely with menus and window functions. And some also swallow the Shift+Alt combination. There's no unified way across systems that could be implemented. It depends on which system, window manager and GUI kit is active whether it's possible or not or how. Try.

See also question/33207

edit flag offensive delete link more


really? thats kinda disappointing. and there isnt a way to implement it by drag and drop? google docs can do that as well as select multiple columns just fine. well, maybe a future update will help.

Mochi gravatar imageMochi ( 2018-02-02 22:57:30 +0200 )edit

Question Tools

1 follower


Asked: 2018-02-02 21:00:41 +0200

Seen: 248 times

Last updated: Feb 02 '18