how to set up a column in excel so it can auto number

  • Thread starter Excel questions
  • Start date
E

Excel questions

I am trying to auto number a column in excel so I do not have to do it. I
tried to Format the cell but i don't see an option to do so.
 
C

CLR

Just type 1 in A1 and 2 in A2 (or any two numbers of whatever sequence you
want)..........then highlight BOTH of them and grab the little black square
in the bottom right corner of A2 and drag it down the column.........if you
want to autofill from there on, one row at a time as you use them, you will
need a macro.......

Vaya con Dios,
Chuck, CABGx3
 
K

Kassie

If you want the row to be numbered only when data is entered in it, do the
following:

In A1 enter a 1
In A2 enter the formula "=IF(AND(B1<>"",B@<>""),A1+1,"")
Copy this down to the end or as far as you want to go.

It checks whether the previous line as well as the current line contains
data, before it will insert a number. If true, it will increment the number
for you.
 
Top