Automatic number sequence in excel

Status
Not open for further replies.

yasir siddiqui

Distinguished
Sep 17, 2011
13
0
18,560
1
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.
Thread starter Similar threads Forum Replies Date
T Apps General Discussion 0
T Apps General Discussion 3
J Apps General Discussion 2
I Apps General Discussion 0
L Apps General Discussion 3
M Apps General Discussion 5
S Apps General Discussion 3
I Apps General Discussion 2
R Apps General Discussion 1
geofelt Apps General Discussion 3
K Apps General Discussion 1
H Apps General Discussion 2
A Apps General Discussion 4
S Apps General Discussion 4
B Apps General Discussion 2
D Apps General Discussion 1
anoori9000 Apps General Discussion 1
LEOKAMBOJ Apps General Discussion 2
tarmiricmi Apps General Discussion 4
P Apps General Discussion 3

ASK THE COMMUNITY