Menu
The easiest way to apply a formula to the entire column in all adjacent cells is by double-clicking the fill handle by selecting the formula cell. In this example, we need to select the cell F2 and double click on the bottom right corner. Excel applies the same formula to all the adjacent cells in the entire column F.
Fill formula without dragging with Name box 1. Type the formula in the first cell you want to apply the formula, and copy the formula cell by pressing Ctrl + C keys simultaneously. 3. Then press Ctrl + V keys together to paste the copied formula to the selected cells, and press Enter key.
Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).
If the formula already exists in a cell you can fill it down as follows:
On Mac, use CMD instead of CTRL.
An alternative if the formula is in the first cell of a column:
Select a range of cells (the entire column in this case), type in your formula, and hold down Ctrl while you press Enter. This places the formula in all selected cells.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With