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?
Mac – Convert dynamic content to static in Numbers
macnumbers
Related Question
- Is it possible to swap two cells content in numbers
- How to prevent Numbers from changing currency automatically
- (Numbers) COUNTIF values from one column match another column
- Generate a new table entry in one sheet from another
- Programmatically convert formulas to their values in Numbers
- Mac Numbers: How to identify cells that match a range of cells from another table
Best Answer
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.)
If you want the static results to persist in your original cells as well, just hit ⌘C ⇧⌘V to paste the results in place.