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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a row without taking formats from above (upper) rows or cells 6
Insert options 1
Single column to multiple columns 5
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Macro to fill down automatically the number of rows in a spreadsheet 1
Sum on top of stacked columns 1
Macro to take to last line and insert new row with number 3
Using insert to paste a row--how done in Excel 2007 1

Back
Top