Have you ever struggled having blank cells in a column that you want to copy down to the next grouping of data in the column, but double clicking only copies to the next bunch of data, making you manually copying them all?
If it frustrates you…
You’re not alone. There is a solution using Go To Special and selecting Blanks.
Watch the short video to learn how. Be sure to listen to the end, because there are two important details to making it work.