Can’t figure out how to do this. You’d think you’d simply highlight the row by double clicking on it on the left side and drag it where you want. That would be logical.
So is there a trick to this? Cutting and Pasting doesn’t work at all or is extremely cumbersome. I can’t imagine doing that all day organizing a spreadsheet.
It works if you got two hands, 3+2 fingers and a trackpoint or mouse…
Select/mark row, then pull selection like if you’d drag&drop over the target row, but do not drop yet, before press Shift+Ctrl+Alt and then let mouse button loose. Ctrl+Alt copies and inserts selection.
Edit: only Alt key before dropping seems to work as well.
To move the row: select the line, drag it, and hold Alt while you release the mouse button. You will see a dark line as the insert position.
This makes (for me*) a =$Sheet1.$A$1 and =$Sheet1.$B$1, etc. being A the original row.
That was new for me.
*LO 7.3.7.2 on Windows 6.3. [EDIT], 7.4.4.2 and 7.5.1.
Select/mark row, then pull selection like if you’d drag&drop over the target row, but do not drop yet, before press Shift+Ctrl+Alt and then let mouse button loose.
Didn’t work initially for me because I didn’t first highlight the data, release the mouse button THEN click to move. Its a 2 step procedure that many wouldn’t assume. In other programs we’re used to just dragging things where we want. I suppose in spreadsheets we need that extra step. Good to know. I’m sure a lot of other things will make more sense now.
To move the row: select the line, drag it, and hold Alt while you release the mouse button. You will see a dark line as the insert position.
Now that was great. No need to add the row beforehand. Just what the doctor ordered!
select a row with a click on the row label;
place the cursor on the highlighted data, click
move to the new location and release the mouse button.
To copy, hold the Ctrl key down,
This worked. Other than having to add a line at the destination its very convenient.
hit Shift+Space to select the row
hit Ctrl+X to cut (or Ctrl+C to copy)
Move cursor to new location, hit ctrl+V to paste
Yes, this has always worked for me before. But it necessitates preparing the destination by adding a row first. Maybe in more complex situations this is useful though.
Thank you all. I hope this helps others. Call it the spreadsheet doubletap!
I don’t get what you mean by that.
Moving data like this will leave a gap in the source range.
In either case, move and copy, data in the target range will be overwritten.
Drag & Ctrl+Shift+Alt+Drop will insert cells before dumping the data the data and it will remove cells where the source range was.
I agree. Indeed I wrote
it are not the rows you move. It is the data.
In a spreadsheet, it are not the rows you move. It is the data.
Yes, I keep on having to remind myself of that. The two have to work independently which is so different from most programs. But it also allows the spreadsheet to do things other programs can’t.
If you prefer the mouse
select a row with a click on the row label;
place the cursor on the highlighted data, click
move to the new location and release the mouse button.
To copy, hold the Ctrl key down,
Keyboard users can
hit Shift+Space to select the row
hit Ctrl+X to cut (or Ctrl+C to copy)
Move cursor to new location, hit ctrl+V to paste
Yes but both of these require a destination to be prepared beforehand. That’s what I was trying to avoid and is what the Alt key gives me by producing that horizontal line that tells me where its going to be inserted. That makes all the difference in the world. Now I can’t imagine living without it!
I deleted my answer, because indeed erArck found the possibility, even if it takes quite some exercise, risks to break your fingers and is not something you would spontaneously “discover”.