Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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.

Posted on May 29, 2022 5:41 AM

Reply
Question marked as Top-ranking reply

Posted on May 29, 2022 6:01 AM

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.

1 reply

Drag copy the same value

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.