Ask Your Question

make formulas adjust after inserting rows

asked 2018-03-13 01:55:06 +0100

COKEDUDE gravatar image

I have several formulas like this:


After I insert rows I want it to change to this:


Is there an easy way to make it auto adjust to this? I always have to go in there and manually change it. Is there an easier or automatic way to do this?

edit retag flag offensive close merge delete



Where do you insert the rows?

m.a.riosv gravatar imagem.a.riosv ( 2018-03-13 02:20:38 +0100 )edit

Do you insert the rows a) before C15, b) after C20, or c) in between C15 and C20? If c, then @Mike Kaganski's answer is not needed.

Jim K gravatar imageJim K ( 2018-03-13 15:23:12 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-03-13 08:30:25 +0100

Mike Kaganski gravatar image

Look at Options > LibreOffice Calc > General; see Expand references when new columns/rows are inserted.

edit flag offensive delete link more


Did you mean C20 to C26? While in formula, on C15, hit F4, absolutes C15 to $C$15. $ meaning it will never change when moved,or rows inserted. C20 to $C20. C will stay the same, 20 will change.

Mark McLean gravatar imageMark McLean ( 2018-03-13 09:49:41 +0100 )edit

@Mark McLean: if OP inserts rows when on row 17, then the behaviour is as OP described; if the insertion is when cursor is on row 10, then it's as you say. No mistake in OP's description.

Mike Kaganski gravatar imageMike Kaganski ( 2018-03-13 09:54:18 +0100 )edit

I didn't know that. Nor did I know about your 1st.comment about options. Glad I put this in comments and not answer!! I will play with both, later. Thanks Mike.

Mark McLean gravatar imageMark McLean ( 2018-03-13 10:47:24 +0100 )edit
Jim K gravatar imageJim K ( 2018-03-13 15:22:04 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-13 01:55:06 +0100

Seen: 20 times

Last updated: Mar 13