Numbers: paste the result of a formula

In Numbers I would want to paste the result of a formula into another cell (i e the formula shall not be pasted)

How is that done ?

MacBook Pro 13″

Posted on Dec 9, 2023 9:52 AM

Similar questions

Basic copying of a formula in Numbers How can I copy the sum formula at the bottom "total" row of one column of numbers across the entire total row to show the sums of all the columns in the spreadsheet. I'm so frustrated. In Excel it couldn't be more simple. You just highlight the cell and drag it across the entire formula and all the cells populate with the totals. I've tried that with Numbers and it doesn't work.
1896 2
Copy and paste forumulas in Numbers Why does Apple make it so difficult to copy and paste a formula from one cell to a range of cells? Could also be I don't know enough about Numbers, but I found this impossible to do. Basically I erased the original formula from the cell, then selected the range of cells I wanted to copy the formula to and couldn't, then I created the formula over again to enter it in the cell range, which recalculated the starting cell with the original formula that I had to delete to do this as well as the cells in the range. Sounds convoluted but it only took a minute to do.
1238 6
Numbers spreadsheet on iPad pro How do I copy a formula down a column, in Numbers spreadsheet on an iPad Pro?
852 3

3 replies

Recycleur

Level 4

1,633 points

Dec 9, 2023 12:06 PM in response to Bomiboll

If you’re asking for an iPhone or an iPad, you tap on the cell and select Cell Actions in the pop-up menu.

Then you tap on the Paste icon…

and at the bottom of the screen you select Paste Values.

Recycleur

Level 4

1,633 points

Dec 9, 2023 11:36 AM in response to Bomiboll

Bomiboll Author

Level 1

78 points

Dec 9, 2023 1:17 PM in response to Recycleur

OK, thanx

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.

Numbers: paste the result of a formula

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