Forum Discussion
Solved
Excel Autofill does not work if there is a blank row between lists
In Excel I have a list of names in column A. When I add a blank row and then start a new list of names, the program will not autofill a name that was previously entered in the first list even through...
That's the way AutoComplete works - it stops at empty cells.
Would it be acceptable to enter a space or the formula ="" in the empty cells? That way, they would still look empty, but Excel would treat them as non-empty.
That's the way AutoComplete works - it stops at empty cells.
Would it be acceptable to enter a space or the formula ="" in the empty cells? That way, they would still look empty, but Excel would treat them as non-empty.
HansVogelaar THANK YOU SO MUCH! Adding the space in the empty row fixed the issue! I really appreciate your response!! 🙂
