How do you add a feature to auto-number the columns in an Excel doc?

Question

I'm sure there's an easy way to auto number a column... I'm just missing it. Thanks.

Answer 1

Sure just make a macro. or if you need it all the time on new pages just make a template.

Or manually

enter the first 3 numbers in the colum and then use the fill handle(the little square arount the cell selected and drag it down. Excel will auto poulate the cells, this works with almost any patterned information.....

Answer 2

I think you need to make a column to auto-number, right?
If so, paste this in the first cell (Say B1)
=1
in the cell below, paste this
=B1+1
and fill B2 to the rest of the cells

OR

Paste this in B1
=ROW()
and fill it down

IF you nymbers are starting from a cell other than first row, say from B5, then paste this in B5
=ROW() -4
and fill it down.

If you want to make a certain cell to auto-number every time you open the file, that is another issue

Mail me, if you want it

Enjoy my profile, I am the VBAXLMan