Ask Your Question

Drag handle fill for a selected range?

asked 2016-12-06 15:51:14 +0100

leeand00 gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-12-06 16:52:34 +0100

pierre-yves samyn gravatar image


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


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-06 15:51:14 +0100

Seen: 539 times

Last updated: Dec 06 '16