3 ms·
then we should be able to select all 99 cells, and enter the formula once without any dragging. Double-click the fill-handle (thing you click on to drag) and E
by jodrellblank 14y ago
then we should be able to select all 99 cells, and enter the formula once without any dragging.
Double-click the fill-handle (thing you click on to drag) and Excel will fill-down as far as the next empty row.
If we want to change that formula, we should be able to change it once and not need to remember to redrag.
How would it know whether you want to change it in one place for a special case, or update many places?