Automatic number sequence in excel

Status
Not open for further replies.

yasir siddiqui

Distinguished
Sep 17, 2011
13
0
18,560
how to generate Automatic number sequence in excel?

if i have 5 rows with column name "Serial No" like this

S Number
1
2
3
4
5

If i insert 1 row between Serial Number 3 and 4 then i want excel to generate auto number sequence and then i should have serial number 1 to 6 like this

S Number
1
2
3
4
5
6
 
Status
Not open for further replies.