Ask Your Question
0

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

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

Mark88 gravatar image

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

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

Comments

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
2

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

Regina gravatar image

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

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

Question Tools

1 follower

Stats

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

Seen: 1,131 times

Last updated: Sep 21 '14