You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Is there a quick way to do a formula in a column in Numbers?

I want repeat the formula RANDBETWEEN(1,6) in a column for 30 times. How can I do this?

MacBook Air

Posted on Aug 8, 2020 7:47 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 8, 2020 8:20 PM

Hi Edward,


Enter the formula in a cell. Hover the pointer over the lower border to see the yellow dot (the Fill Handle).



Drag the yellow dot down as far as you need.


Regards,

Ian.

1 reply

Is there a quick way to do a formula in a column in Numbers?

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