Drag handle fill for a selected range?

If I enter a formula into a cell such as =B1/B$41 and then grab the handle in the lower left corner and drag it down to a selected row in the same column so that subsequent cells will have =B2/B$41, =B3/B$41, =B4/B$41 etc… how can I do this auto fill automatically?

So far I’ve found selecting from the menu Sheet -> Fill Cells -> Series, but it doesn’t fill in the formula, it only fills in the values.


With you formula in (e.g.) A1 and the range to fill A1:A10, select A1:A10 then Ctrl+D or SheetFill CellsDown

You can also select A1:A10 before typing the formula, type the formula and validation with Alt+Enter