Ask Your Question
1

make formulas adjust after inserting rows

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

COKEDUDE gravatar image

I have several formulas like this:

=SUM(C15:C20)

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

=SUM(C15:C26)

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

Comments

1

Where do you insert the rows?

m.a.riosv gravatar imagem.a.riosv ( 2018-03-13 02:20:38 +0200 )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 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

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

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

Comments

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 +0200 )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 +0200 )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 +0200 )edit
Jim K gravatar imageJim K ( 2018-03-13 15:22:04 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 23 times

Last updated: Mar 13