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.

How to move a formula in Numbers?

Let's say I have a formula in cell A1 that references values in cells B1 and B2. How can I move (not copy) this formula to cell A7, such that it continues to reference the values in cells B1 and B2?


Control-X followed by Control-V accomplishes this in MS Excel, and I am wondering if there is a. similar keystroke combination in Numbers.


Thanks,

MacBook Pro 15″, macOS 10.14

Posted on Apr 29, 2021 5:40 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 29, 2021 5:59 AM

pomme4moi wrote:

similar keystroke combination in Numbers.


Not exactly a keystroke, but in Numbers you can select the cell with the formula you want to move, hold down the mouse key (or trackpad equivalent) and drag it to the new position.


SG



2 replies

How to move a formula in Numbers?

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