How to insert a number sequence in irregular rows or columns of Excel - just as 'Listnum' field woul

  • Thread starter Thread starter av
  • Start date Start date
A

av

Hi,

I cannot find in the Help files of my Excel '97 how to insert, in
effect, a field which would increase by one every time I copy it
into a different cell. I only know how to insert such a series
over a contiguous set of rows or columns using the Edit>Series
menu.

Does anyone here please have an answer to this problem? Or is
there one??

Thank you for taking the trouble to read this enquiry.

avril
 
To create sequential numbers in column A, enter the following formula in
cell A2:

=MAX($A$1:A1)+1

Copy this formula to another cell in column A, to create the next number.
 
Debra Dalgleish said:
To create sequential numbers in column A, enter the following formula in
cell A2:

=MAX($A$1:A1)+1

Copy this formula to another cell in column A, to create the next number.
Click to expand...
series

Thank you Debra. I will certainly use that.
avril
 
Back
Top