# Sequential Numbering Excel 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### irvinbang

Not sure if this question has been asked or not i tried to search but i cant seem to find anything on the forum. So my question being:

A1=1
A2=2
A3=3
A4=4
A5=5
A6=6

But here is the kicker if i delete one of the other numbers i want it to auto fix the rest of the numbers and continue:

A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4

So any ideas? Thanks in advance for the help!

#### ChuckE

If the sequence you want is:
A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4
Then just enter:
A1=1
A2=blank
A3=2
Then select those three cells (A1, A2, and A3)
Grab the grabpoint at the bottom right of cell A3 and drag downward.

From that I got:
A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4
A7=5
A8=blank
A9=6
A10=7
A11=blank
A12=8
A13=9
A14=blank
A15=10
A16=11
etc.

#### irvinbang

Not really what i had in mind. I understand that part of the way the little box works down at the bottom right hand of the cell when selected.

What i mean is if you delete any number no matter it if goes from 1 - 1000 it will auto correct and keep numbering the way it should.

Cause some times i might have more spaces between numbers than others. That was just an example of a few cells. I meaning on a much larger scale.

But thanks for the input!

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On