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

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


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”

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

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

There’s a bug report (with additional information) on https://bugs.documentfoundation.org/show_bug.cgi?id=39936 . Anyone can add himself to the CC List, too (to receive information, also with a bigger CC list the issue will look as important as it is)

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 (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.