Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Autonumber in Excel
Autonumber in Excel
To create an autonumber field, can use the Offset() function.
In cell A1, enter the number 1.
Then in cell A2, enter this formula:
=OFFSET(A2,-1,0)+1
Then copy the formula from cell A2, down as far as you need.
See also: Autonumber in Excel forum post.
Added by Garry on 3rd October 2006
More Excel hints and tips, like:
- How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet
- Stop Formula Returning A "#DIV/0" Error
- Go to source of a cell
 |
|
» Forum post: Excel |
Discover The Different Kinds Of Task Relationships In Microsoft Project Have you created or used a project plan in Microsoft Project? Then you'll know that the key way tasks interact is through task relationships. Find out in this article about the four different kinds of task relationships and how to create them. » Article: Microsoft project training |
When you go into the columns and hide them, how do you unhide them?
