Can I set up sequential numbering in a colum in excel

Q

Quitefriendly1

I need to set up a colum with sequential numbers ie 1001, 1002, 1003 and so
on I need to do it on Excel but cant find how on the help, im using Office
2000. Can anyone help please

John Wilson
 
F

FSt1

hi,
enter your first number where you want it then high light the column you
want it in. click edit>fill>series. follow the instructions.

regards
FSt1
 
Q

Quitefriendly1

Thank you, I did as you said but got only the number I entered tried several
times but ended with the same result

regards QF
 
G

Gord Dibben

Try this

Enter 1001 in A1

Right-click on the bottom right corner of A1 and drag down a ways until you
reach "so on"

Let go the mouse button and select "Fill Series" from the options.


Gord Dibben MS Excel MVP
 
D

David Biddulph

"FSt1" wrote:
Click to expand...
Thank you, I did as you said but got only the number I entered tried
several
times but ended with the same result
Click to expand...

What did you have as the "step value" in the Edit/ Fill Series dialogue box?

Are you sure you didn't do Edit/ Fill DOWN, rather than Edit/ Fill SERIES?
 
Top