I'm typing a string of consecutive numbers in individual cells.
After completing the string, I go back and delete the contents of one of the cells in the column.
Is there a way that Excel can then automatically adjust the numbers in the rest of the column so that they remain consecutive?
1 2 3 4 5
Then I delete the value (but not the cell)
Can Excel adjust the rest of the numbers so it looks like this:
1 2 3 4