Excel Top Tip #6

The Autofill handle in Excel (little black box at bottom right of a selection) is very powerful. It can help you quickly fill individual values and series. Double-click on it to have it copy the current cell down to the bottom of the adjacent column, keeping two columns in sync with each other.

A double-click is all it takes