Solved

Insert auto number in excel

Posted on 2006-10-26
2
327 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
This article was originally published on Monitis Blog, you can check it here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

617 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