Quick copy in Excel

Subscriber Karen L. asks "In Excel, is there a quick way to put a formula in a column and copy it to all cells to the end of the column?"

If you have a formula that you want to copy to the cells below, AutoFill is probably the quickest way to do this. Select the cell with the formula then move the mouse pointer over the bottom right corner of the cell.  When the mouse pointer changes to a small black plus sign (the AutoFill handle), double-click. 

This will copy the formula to the cells below until it finds a blank cell on the left.  This works well as long as the column to the left has no, or very few, blank cells.

If the column to the left has many blank cells, here's an alternate approach:
 - Create the formula in the first cell in the column
 - Use the keyboard (Ctrl+End or Ctrl+Down Arrow) to get to the end of the spreadsheet
 - Select the last cell in the column that has the formula you want to copy
 - Select all cells in the column: Shift+Ctrl+Up Arrow
 - Move the active cell to the top of the column: Press the Tab key
 - Copy the formula to the selected cells below: Ctrl+D

Any questions, please let me know.

Interested in Microsoft Excel Training in Vancouver?

Back to tips