Fill an Entire Column with One Double Click
In construction financial worksheets, like loan amortization schedules or capital lease schedules, you are often faced with the task of building a formula and copying it down dozens or even hundreds of cells. In these situations, there is frequently an adjacent column that goes down as far as you would like to copy the new formula. In these cases, simply double click on the fill handle in the cell to fill the entire column with the formula all the way down as far as the adjacent cell has data.
