Solved

Insert auto number in excel

Posted on 2006-10-26
2
313 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

680 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