I have used some formulas in Numbers and I would like to change the dynamic values to static ones, so I can copy them to different sheets, without having any reference errors.

Does anybody know how to do that?


Select and copy the source cells, then hit ⇧⌘V, which is the default shortcut for the Edit » Paste Formula Results menu command.

(I assume that by dynamic value, you are referring to the the result of the calculation of an entire formula and not to the individual cell references you are using as part of the formula’s expression. Feel free to update and clarify your question if you disagree.)

Screenshot of the menu command Edit » Paste Formula Results

If you want the static results to persist in your original cells as well, just hit ⌘C ⇧⌘V to paste the results in place.

  • (+1) This is exactly what I was looking for! Thanks! – thanasissdr Apr 2 '17 at 14:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .