Click and drag to select all the cells you want to fill. They'll magically fill using the pattern you started—up or down a column, or left or right on a row. Even better: Try Auto Fill without much of ...