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?
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?