how to copy the value of a formular and not the formular

I want to copy the value of a formula to another cell but not the formula itself.

Current Pro Desktops

Posted on May 19, 2019 10:56 PM

Top-ranking reply

Yellowbox

Level 7

21,939 points

Posted on May 20, 2019 12:33 AM

Hi manopaele,

Copy the cell(s) with the formula.

Click where you want the value(s).

Menu > Edit > Paste Formula Results.

Regards,

Ian.

View in context

Similar questions

copying data without formulas or deleting formulas while retaining data If I have a column that has a number that resulted from a formula in that cell and I want to copy that number (that column of numbers) to a new row that does not have any formulas (so I can adjust the numbers at will) how to do that. If I copy and paste the column it copies the formulas as well.
563 1
Copy/Paste Numbers Copy/Paste doesn't work as it should, I copied a formula from a cell hoping to copy it for the rest of the column, turned out after pasting, the formula changed. I noticed after entering the formula, It copied the data/text in the cell. Thanks in advance.
3401 7
copying a row of numbers I have a row of numbers that were created using a formula. How do I copy just the numbers without the formulas to a new document
428 1

1 reply

Top-ranking reply

Yellowbox

Level 7

21,939 points

May 20, 2019 12:33 AM in response to manopaele

Hi manopaele,

Copy the cell(s) with the formula.

Click where you want the value(s).

Menu > Edit > Paste Formula Results.

Regards,

Ian.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how to copy the value of a formular and not the formular

Welcome to Apple Support Community

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

Learn more Sign up