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
=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.