When dragging the fill handle what activates the auto-fill feature in excel?
It will copy the formula to other cells. If the cell references
are relative, they will change. If they are mixed, they may or may
not change, depending on which way the cells are referenced and the
direction the cells are being filled. If they are absolute, they
will not change.