Thread: 1-100
View Single Post
  #1   Report Post  
schaduw - ExcelForums.com
 
Posts: n/a
Default 1-100

Is it possible to have row A numbered from 1 to 100, and if one of the
numbers is removed the count will automatically change?

i.e.
1
2
3
4
etc.

Now 2 gets deleted, how can i get excel to change 3 to 2 and so on for
the rest of the numbers.

hope this makes sense at all :?
---------
www.coffeecozy.com

Use your Bodum and give up cold coffee for good!