Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Insert auto number in excel

Posted on 2006-10-26
2
Medium Priority
?
335 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 2000 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This video shows how use content aware, what it’s used for, and when to use it over other tools.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

721 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