View original (French)

How to create automatic line numbering?

sekouausud -  
 sekouausud -
Hello,

I have a sheet containing a data table. In one of the columns, column A for example, there are row numbers from 1 to 500, but I may delete or insert one or more rows as needed and each time I redo the numbering.
So, I am looking for a formula to insert in column A so that after each deletion or insertion of rows, the numbering in this column A updates automatically.

Thank you in advance to the entire CCM community.

2 answers

  1.
    Gyrus Posted messages 3360 Status Member 526
     
    Hello,

    You can use the ROW function.
    =ROW() returns the row number of the cell in which the function appears.

    See you!
    0