Quickly Copy Data Down a Column

To quickly copy data down a column, try double-clicking on the fill handle. Excel will automatically copy down the current column, and stop at the last non-blank cell in the preceding column. The Fill Handle is the little notch in the bottom-right hand corner of the active worksheet cell.