Hello

any help appreciated, i'm not an excel expert use a regular PC win 10 user with the Office 2016 suite.

I know how to autofill a column with numbers in a sequence, ie.
1
2
3
4
5
Lets call this column 'Numbers'. And the next column is 'Books'. I use this to keep a book list. When I give a book away, I delete a row and it is a nuisance updating the numbers each time. They need to be sequential order to show me how many books remain. This is because a number in the 'Books' column is missing each time I delete a book.

How can I autofill a column so that if I delete a row the numbers remain sequential? So for example, if I sell Book 3 and delete this row, I want the 'Number' column to change Book 4 to Book 3 automatically.

I only need the 'Number' to automatically 'renew' itself if that makes sense.

Thanks for any advice.