I have an excel workbook with a numbered list. I need to learn a function in Excel 2016 that are automatically adjusting numbers if any of them is deleted. Let us say that the list is from 1 to 450, if number 3 is deleted, I need a formula that automatically changes the other numbers in sequence so that number 4 changes to number 3 in the following row and so on.

1              1
2              2
3     =>
4              3
5              4
6              5
Thank you for spending some of your valuable time to read this!