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.
Hello,
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.
2 Likes
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?
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.
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
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.