Forum Discussion
Auto Fill columns based on filled cells to the left
Older versions of Excel would let me fill a column to the row level with the data left of that row. Now when I double click the autofill handle in the first cell, it fills all the way down to match t...
Yes, former time it worked differently. But there were issues with blank cells in the middle of adjacent column. After the the improvement, or now if you don't consider that as improvement, fill handle works till last not blank cell in both adjacent columns, like this
To my knowledge there is no way to change such behaviour. Workaround could be (as in your sample if you stay on the first cell of third column)
Left
Ctrl+Down
Right
Ctrl+Shift+Up
Ctrl+D