Auto Serial Number

[sms1432]

Hi Everybody,

again i need some help on auto serial numbering, Say I have rows 1-10 (numbered) in column A, I then insert a row, say between 5 & 6 is it possible I can set them to auto re-number automatically.
kindly help

Thanks.

[FDibbins]

Hi Everybody,

again i need some help on auto serial numbering, Say I have rows 1-10 (numbered) in column A, I then insert a row, say between 5 & 6 is it possible I can set them to auto re-number automatically.
kindly help

Thanks.

Short answer - no, not without VBA

[zbor]

You can write formula in A1 =ROWS($A$1:$A1) and drag it down.

Once you insert desired number of rows you can drag formula from above to fill empty (new) cells and then double click black cross in the bottom right corner to fill formula all the way down.

Untitled.png

Similarly when you deleting rows.

It's not automatic.. But let's call it semi-automatic

[FDibbins]

zbor, like you said, that wont auto-"add" row numbers if a new row is inserted
(that was my understanding of what the OP wanted)

[zbor]

zbor, like you said, that wont auto-"add" row numbers if a new row is inserted
(that was my understanding of what the OP wanted)

I agree, I've got it that way too.
I've just give an approach if user don't want to use VBA (that would be solution here) and still want to handle it quickly.

[FDibbins]

I agree, I've got it that way too.
I've just give an approach if user don't want to use VBA (that would be solution here) and still want to handle it quickly.

And a good work-around it was, too (as is cbatrody's)

[cbatrody]

OR,

In A1=ROW()

Again, as mentioned by zbor, this will be a semiautomatic solution