A simple solution to numbering a row even if we delete or add a rows in between the serial numbers.
Formula for numbering the row is “=Row()” . This formula will then publish the number according to the Row number on the right ruler.
This formula will also automatically indicate the row number whenever there's some changes in between the list or a tab
To start a different row number, the follow method can be applied.
Start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.
That's all for out posts. Thanks for reading
Formula for numbering the row is “=Row()” . This formula will then publish the number according to the Row number on the right ruler.
This formula will also automatically indicate the row number whenever there's some changes in between the list or a tab
To start a different row number, the follow method can be applied.
Start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.
No comments:
Post a Comment