Auto Serial Number

Originally Posted by 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.

Short answer - no, not without VBA

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

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)

Originally Posted by zbor

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)