Fill Handle

Move your mouse pointer to the bottom right corner of the selected cell. You should see a small black square, which is the fill handle. Double-click the fill handle. This will automatically copy the formula down to the end of your data, matching the rows in adjacent columns.

edu.gcfglobal.org