Ask Your Question
0

LO 6.3 Calc: Move multiple rows by cutting & insert cutted cells.

asked 2020-01-06 12:26:02 +0100

artofit gravatar image

updated 2020-08-07 21:57:21 +0100

Alex Kemp gravatar image

LO: 6.3

Suppose you have in Calc a sheet:

  • with row 1 to 20 filled with data; for ease of clarity fill column A with 1 to 20 as you go with the rows.
  • and desire to move rows 4 to 6 below lines 15.

Traditionnaly, in MS-Excel:

  1. you select rows 4-6, then CTRL-X to cut them,
  2. then on line 16 do a right-click and select the menu "insert cut cells".
  3. DONE

In Calc I can:

  1. I can CTRL-X the rows 4-6
  2. on line 16 make a special paste with CtRL+MAJ+V
  3. In the paste special menu, select the option "Shift Cells" choose option "down" and be sure that ALL other options are correct as it is a paste special.
  4. then delete the empty rows 4-6

DONE

In Calc, this is way more cubbersome, no better way? Feature request for LO6.4 or later?

OF course same applies to columns

P.S. In Tools>Personnalize>Menus I haven't found any command such as "insert cut cells"

edit retag flag offensive close merge delete

Comments

I would strongly support this function. Although Calc is already better than Excel in quite some respects, 'insert cut sells' is what I keep on missing in Calc

henkjan_nl gravatar imagehenkjan_nl ( 2020-05-10 14:06:42 +0100 )edit

I also miss this (and pretty much only this) from Excel

andyroo gravatar imageandyroo ( 2020-05-26 20:23:27 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-11-24 23:56:37 +0100

LeroyG gravatar image

updated 2020-11-24 23:57:05 +0100

You can drag the rows and drop them while holding Alt.

And allow me to reorder your algorithm to make it a bit efficient:

  1. Ctrl+X: to cut the rows 4-6
  2. Ctrl+-: to delete the empty rows 4-6
  3. Insert (or Ctrl+Shift+V): on line 16 to open the special paste dialog
  4. Alt+W (be sure that ALL other options are correct as it is a paste special) and Enter: to select the Down option for "Shift Cells" and paste.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.


Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-01-06 12:26:02 +0100

Seen: 395 times

Last updated: Nov 24 '20