Hi there wizards! I am looking for a way to autofill a column with multiple values (with each value having multiple blank spaces below it) without having to double click the autofill square each time.

Capture.JPG

For example, I want 'Diamond' to autofill all blank cells below it and stop before 'High Potential' and then do the same thing for 'High Potential', etc, etc.

Elsewhere, I've seen a solution of clicking the first cell, and then holding CTRL+SHIFT+DOWN and then using CTRL+D to autofill down, but unfortunately this method also highlights the next cell after the last blank one.


Thank you!