CODEWITHSUNDEEP
excelexcel-formula
Francis Saul
Francis Saul

Reputation: 740

How to update row value automatically in excel

How can I update the row values automatically in cell ? Please see below image enter image description here

If I change the value of "1" to "12" I want the down arrow cells to follow from it but increment by 1 like the image below

enter image description here

Upvotes: 0

Views: 993

Answers (2)

Praveen Behera
Praveen Behera

Reputation: 444

Write formula - =1 + A1 and drag it down to your limits.

change value 1 to any value, it will follow the increment as you want.

Upvotes: 2

Tim Biegeleisen
Tim Biegeleisen

Reputation: 521073

Assuming that the value 1 in your first image is cell A1, then yo7 can enter the followint formula into A2:

=A1 + 1

Then, copy this formula down the A column as far as you need. Now when you change the value of A1 to some other value, the whole column should update.

Upvotes: 1

Related Questions