Wednesday, November 29, 2017

Excel Automatically number rows so cut and paste works

=Row()-number

number = number of rows down the list.
Then you can cut and paste and it will keep the correct numbers.

In the example Row()=3; number = 2; 3-2=1

No comments: