EXCEL 2010 Auto numbring a column

[Dick7Access]

Is there anyway to Auto number a column in a spreed sheet?

 

[pwbrown]

Can you maybe explain what you want? There are plenty of ways you can autonumber by dragging a series of numbers etc. or using formula's.

 

[Dick7Access]

Can you maybe explain what you want? There are plenty of ways you can autonumber by dragging a series of numbers etc. or using formula's.

Thanks for answering. Since posting this another source has answered. I know next to nothing about excel. What I had to do was add a number field. They told me to enter a formula A1+1 and drag it to the end record and it gave me the whole run of numbers from 1 to 343.

 

[Brianwarnock]

So is 2010 different to the olde r releases when you could fill down series without any formula required?

Brian

 

[Dick7Access]

So is 2010 different to the olde r releases when you could fill down series without any formula required?

Brian

I don't know as this is my first venture into Excel, and the only reason I am there I have to convert data from one db with different tables and different fields and the worst part different primary key.

 

[pwbrown]

So is 2010 different to the olde r releases when you could fill down series without any formula required?

Brian

Nope, you can still do that.


@Dick7Access you should use =ROW()-ROW(A$1) instead of A1+1.
So if you delete a record it will re-arange the auto-numbers where as A1+1 will give you errors.
It depends on your needs.

 

[Brianwarnock]

As he is starting in row 1 he would need to +1 to that formula, but then as he is starting in row 1 he only needs =ROW()

I stll think that fill series is the simple way if he does not need to be dynamic, and to be dynamic, that is to allow for additions and deletions would require some nifty code in the worksheet change event.

Brian

 

[pwbrown]

As he is starting in row 1 he would need to +1 to that formula, but then as he is starting in row 1 he only needs =ROW()

I stll think that fill series is the simple way if he does not need to be dynamic, and to be dynamic, that is to allow for additions and deletions would require some nifty code in the worksheet change event.

Brian

I normally use the fill myself but it depends on your needs.
Oh crap, completely forgot it's for columns. In that case: =COLUMN() -1 will work perfect, remove the -1 if you want it to start from 1 instead of 0.

 

[Brianwarnock]

I normally use the fill myself but it depends on your needs.
Oh crap, completely forgot it's for columns. In that case: =COLUMN() -1 will work perfect, remove the -1 if you want it to start from 1 instead of 0.

No its for numbering the rows in a column.

Oh and I realised that the Change event would send you into an endless loop, but you could easily do a complete renumber in the Workbook before save event or some such.

Brian

 

[pwbrown]

No its for numbering the rows in a column.

Brian

I'm confusing myself now.
Then =ROW()-ROW(A$1) will work perfect. If you want to have the autonumbers start from 1 then you add one, but as a general rule I always start with 0.

 

[Brianwarnock]

Why not ROW()-1

Brian

 

[pwbrown]

Why not ROW()-1

Brian

That will work just the same, I just copied code I had from an open worksheet which started a few columns down.
As I said it depends on his needs.