excel for mac versions 16 copy formula down column

Note: You can use this way to select the entire column for formula copying since the column with the formula is the last one populate. On your keyboard, press CTRL + SHIFT + END to select the paste range, right-click the selected area, and choose Paste (or use the keyboard shortcut CTRL + V).Right-click the cell from which you want to copy the formula (D2), and choose Copy (or use the keyboard shortcut CTRL + C).Copy-Paste FormulaĪnother approach for copying the formula is to use the copy and paste functionality. Note: See how to lock a cell reference in the formula if needed. Since Column C has 8 rows populated, the formula in Column D is applied through Row 8. In this case, the last row for copying the formula is determined by the number of rows in the adjacent column. If you want to apply the same formula to the entire column (through Row 8), position the cursor in the bottom right corner of the cell with the formula (D2), and drag it to the end of column (Row 8).Īs a result, the formula is copied to the rest of cells in the Column D.Īpart from dragging, you can also double-click the fill handle to apply the formula to the entire column. Say you have the formula in cell D2 that sums values from Columns B and C. This tutorial demonstrates how to apply a formula to an entire column in Excel and Google Sheets.įill Formula Down Entire Column Drag Fill Handle

Excel for mac versions 16 copy formula down column