I love new tricks like this one, click on the article for all the details and illustrations. Steve
"use the fill handle. It’s a bit tricky until you get the hang of it. First, select a column or row. Then, hold down the [Shift] key and drag the fill handle one column to the right (or left).�If inserting a row, drag the fill handle up or down."
