Solved

Insert auto number in excel

Posted on 2006-10-26
2
302 Views
Last Modified: 2012-08-14
I would like ot insert auto incrementing number ( 1,2,3,4,5,6,....etc)

how cna I do this?
0
Comment
Question by:jung1975
  • 2
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 17815834
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:
=ROW()-ROW($A$5)+1

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,

Brad
0
 
LVL 81

Expert Comment

by:byundt
ID: 17815851
jung1975,
Thanks for the grade!
Brad
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let’s list some of the technologies that enable smooth teleworking. 
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now