Insert auto number in excel

I would like ot insert auto incrementing number ( 1,2,3,4,5,6,....etc)

how cna I do this?
Who is Participating?
byundtConnect With a Mentor Commented:
Hi jung1975,
The ROW() function is frequently used for auto-incrementing numbers. It returns the number of the row. As you copy the formula down, it increases by 1.

Starting with cell A5, your formula might be:

If you insert or remove rows, the incrementing will be untainted.

A different approach:
1) Put a 1 in the desired cell, then a 2 in the cell beneath it.
2) Select both cells
3) Drag the little square at the bottom right of the selection marquee down. Excel will automatically increment the number for you.

Hoping to be helpful,

Thanks for the grade!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.