SOLVED

Excel Autofill does not work if there is a blank row between lists

Copper Contributor

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 it's still in the same column.

 

Example:

Adam B

George G

Henry K
BLANK ROW

Ge - This will not suggest to autofill with "George G" from the previous list on Row 2

 

I am using a Mac computer. I have contacted support and they are able to re-create my issue but cannot fix it. It was suggested I post my issue here in hopes someone else can help me. I'm not sure if there is a function or rule I can add so every spot in the entire column autofills if there is a duplicate, regardless of the blank rows.

2 Replies
best response confirmed by UltimateGymnastics (Copper Contributor)
Solution

@UltimateGymnastics 

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.

@Hans Vogelaar THANK YOU SO MUCH! Adding the space in the empty row fixed the issue! I really appreciate your response!! :)

1 best response

Accepted Solutions
best response confirmed by UltimateGymnastics (Copper Contributor)
Solution

@UltimateGymnastics 

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.

View solution in original post