Drag copy the same value
How do I drag copy the same value from one cell into multiple other cells? If I click the yellow ball centre it copies sequential values into the cells. I want to paste the same value.
Question marked as
Hi Stuviner,
Give Numbers a hint. Type the number into 2 cells. Select them both and drag the yellow fill handle down.
This also works when filling to the right (or left, or up).
Regards,
Ian.