Auto Increment Office XP Excel Spreadsheet ?

C

Chris

I have Excel and would like to have my first column auto increment so that
if add new rows it will auto update the the numbers. Something like:

1.
2.
3.
and so on

How can I make the first column in every row auto increment?

Thanks so much in advance!

Chris
 
R

Robert Rosenberg

There's no automatic way. You can use a formula (or a range name) that takes
the number in the cell above and adds one to it. However, if you insert a
row in between other rows in your list you'll still have to copy the
formula/range name down from the cell above.

There is a Data-->Form command that allows you to enter list data using a
dialog box. The advantage of using the dialog is that it automatically
copies down any formulas in your list when adding new records. The drawback
is that the copyin only works when adding records at the bottom of the list,
not after inserting blank rows within a list.
 
J

Jim

In recent versions, there are always 65,536 rows. That number cannot be
changed. If you are not seeing the row number on the left (US version), go
to Tools>Options>View tab and check the Row and Column headers box.
 
M

Murthy

One way:
If the serial numbers start from A2, and your corresponding data starts from
B2, you can enter this formula in A2 and copy it down - well, depending on
your requirements.

=IF(B2<>"",ROW()-1,"")

Whenever there is an entry in Column B, the serial numeber will show up in
Column A.

You may suitably modify this to your requirements.

Regards,
Murthy
 
Top