The two ranges a fill actually runs over — what it reads, and what it writes.
Remarks
Worth showing, because they are not the selection and not obvious from it: the template is the
selection's leading CONTENTFUL part, so typing a second seed value changes what the fill reads.
Excel keeps this hidden and always seeds from the first cell, which is why nobody can tell what
its dialog is about to do.
The two ranges a fill actually runs over — what it reads, and what it writes.
Remarks
Worth showing, because they are not the selection and not obvious from it: the template is the selection's leading CONTENTFUL part, so typing a second seed value changes what the fill reads. Excel keeps this hidden and always seeds from the first cell, which is why nobody can tell what its dialog is about to do.