In almost all of my spreadsheets, my first column is an line number / index number column. I code this as such:
A1 1
A2 =A1+1
A3 =A2+1
A4 =A3+1
A5 =A4+1
A6 =A5+1
But this is not a very powerful or forward-looking way to do it, however.
If I delete the 4th row, for example, rows 5 and 6 will return #REF!.
...and if I move a row, the numbers will no longer be sequential.
There must be a better way to do this, something embarrassingly obvious that I'm missing.
Any suggestions?
Thanks.
A1 1
A2 =A1+1
A3 =A2+1
A4 =A3+1
A5 =A4+1
A6 =A5+1
But this is not a very powerful or forward-looking way to do it, however.
If I delete the 4th row, for example, rows 5 and 6 will return #REF!.
...and if I move a row, the numbers will no longer be sequential.
There must be a better way to do this, something embarrassingly obvious that I'm missing.
Any suggestions?
Thanks.