Ask Your Question

How can I cut rows in Calc and have these rows automatically deleted? [closed]

asked 2014-09-19 18:24:26 +0200

Mark88 gravatar image

updated 2016-03-03 22:16:17 +0200

Alex Kemp gravatar image

In Calc, when I cut a row and insert somewhere else the rows are left blank where I cut from (i hate that) AND the formulas don't transfer correctly. Formulas in both the row I cut and in rows I haven't cut get rearranged incorporating other cells. Libre Office 4, English, Calc

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 22:16:35.627325


Please what is the question?. Can you explain step by step a single sample, and what is the bad result or wrong formulas?

m.a.riosv gravatar imagem.a.riosv ( 2014-09-19 22:57:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-20 23:36:53 +0200

Regina gravatar image

updated 2014-09-21 23:53:32 +0200

Do not cut&paste but drag&drop. Mark the row to be moved. Grip the first cell of the row and drag it to the new position and hold down the ALT-key while releasing the mouse button, see help topic "Moving Cells by Drag-and-Drop".

edit flag offensive delete link more


Thanks! That worked perfectly.

radiodave gravatar imageradiodave ( 2020-03-29 06:09:59 +0200 )edit

Question Tools

1 follower


Asked: 2014-09-19 18:24:26 +0200

Seen: 1,731 times

Last updated: Sep 21 '14