Monday, June 04, 2007


Every so often I have a worksheet with many rows and I need to copy a formula from one row all the way down to the last row. Using the Fill Handle I drag the formula down to the last cell in the row. When there are hundreds of rows involved this can take a long time. What I did not know about until recently is the double-click option. Double-click the fill handle and Excel copies the entry all the way down through the last active cell in the row.

Need to create a column with sequence numbers from 1 to the whatever? Enter a 1 in the first cell and a 2 in the second cell, select both cells, and then double-click the fill handle. Excel completes the sequence all the way down through the last cell in the series.