I am stuck with one issue which needs your help. Because of some bad requirement i am supposed to write my test cases in excel. Now Each Test case has a Serial Number. Because the test cases are more than hundred, if i add some test cases in the middle, I have to re-number the subsequent test cases manually. Is there any automatic way like formula or something which can do that for me. Below is the Example.

Now if i add a new test case between Test Case #1 and Test Case #2, I want newly added case to be numbered as #2 and test case #2 to be renamed as #3 and #3 as #4 automatically, similarly all the subsequent test cases to be re-numbered accordingly. Is it possible to do in excel ? I tried to tweak around with row() and offset() function but not able to figure out the exact solution. I hope my question makes some sense and is clear to understand.

Thanks for your time.