Automatic update of numeric increment

Question

I use Excel 2013 but I do not know how to have a column with incremental numbers update automatically whenever I delete or add a row.

How can I achieve that?

Example

If I delete row 02, I would like that the program automatically sets the following row as 02 instead of 03, etc and if I add a row between 03 and 04, then that added row should show 04 automatically and 04 become 05 and so on.

You want this value in the 1st column ? – Fabien TheSolution Nov 01 '13 at 01:08 — Fabien TheSolution, Nov 01 '13 at 01:08

score 4 · Accepted Answer · answered Oct 31 '13 at 23:02

4

Use =Row() or that plus an offset, if required.

answered Oct 31 '13 at 23:02

pnuts

58,317
11
87
139

please be more explicit I don't understand your answer – AMDG Oct 31 '13 at 23:26
1

This is the answer (as I understand the question) – guitarthrower Nov 01 '13 at 22:06

score 0 · Answer 2 · answered Oct 31 '13 at 23:00

0

You may write value as =, then address of upper cell (press up) and then +1. E.g. for cell B2 it would be =B1+1. Then hold mouse button on the bottom-right angle of that cell and drag mouse bottom as far as you need.

answered Oct 31 '13 at 23:00

kirilloid

14,011
6
38
52

but when I add a row, that cell is without =B44+1 – AMDG Oct 31 '13 at 23:25
and also the formula is broken. in short it does not update automatically my whole column – AMDG Oct 31 '13 at 23:30
If you use an Excel Table (Insert Ribbon > Table) then formulas will carry over into new rows automatically. – teylyn Nov 01 '13 at 07:52

Automatic update of numeric increment

2 Answers2