How do I autofill numbers in an Excel file if I want it to stop at the first empty cell? I am trying to format multiple Excel files through Access. The Excel files already have numbers in the field but I want to change them because from the source the numbering starts at 0 and not 1. All I want is a simple count, column A would need a 1, B a 2 and so on.