Originally Posted by
Teacher49
EricH, I am probably being dense, but ... if I enter this longer string of characters in each row in column A, does it ever become automatic in the sense that:
- next row will be labeled with a number one higher than the preceding row AND
- perhaps more importantly, if I insert or delete a row for a new or departing student, can the rows in column A be made to readjust?
If this is too much to explain, not to worry and thanks for your help thus far!
The equation EricH gave you will automatically add one to the number in the preceding row. In the first row you want numbered, type
1. In the next row (assuming the
1 is in row 4), type
=A4+1. The
=A4+1 will add one to the previous number. Copy this equation as far down the sheet as you like. It will automatically adjust from A4 to A5 to A6, etc as you copy it.
If you insert or delete a row, your numbering will be thrown off... but easily repaired. Just copy the equation from the row above the change & copy it down to the row below the change. (If you add a new row 20, copy A19 into A20 & A21. If you delete row 31, copy A30 to the new A31.)