View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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