Auto-update row numbers after inserting new row
If you put this formula in A1:
=ROW()
and copy it down as far as you need, then it will always show the
correct row. If you insert a new row, however, then the new row will
not have the formula in it.
Hope this helps.
Pete
On Jan 23, 11:46*pm, carusso
wrote:
I have a spreadsheet with Column A numbered sequentially using auto fill
series. *If someone adds a new row between 2 existing numbered rows, is there
any way to automatically update the row numbering?
Thanks!
--
carusso
|