Is it possible to make a Starting number in an excel workbook in column a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--

=A1+1
copy down.
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Muddled" wrote:

Is it possible to make a Starting number in an excel workbook in column a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--

try
=row(a1)
or
=$a$1+ROW()-1
to compensate for row deletions.

--
Don Guillett
SalesAid Software

"Muddled" wrote in message
...
Is it possible to make a Starting number in an excel workbook in column
a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--