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.
Mar 25
Quickly Copy Data Down a Column
