Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

NMC-indy Author

Level 1

5 points

Copy formula in cell without copying results in that cell

I have a list of cells with formulas; all of them have results in the cells. I'd like to copy this stack of cells to another sheet without having to recreate the formulas, but all I get when I paste, is the numeric result rather than the formula. Is there a way?

Posted on Mar 11, 2018 4:50 PM

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.
582 2
Copy and Paste Formula Numbers Version 6.1 Hi, I am simply trying to copy the exact same formula from one cell and paste it on an entire column but every time I copy+paste, the cells from the original formula shift. How do I keep the formula from shifting? Example: copy this formula... ... On this cell... ... but instead, the formula shifts! How do I keep it from shifting? Please help! Thank you!!
2572 3
How can I copy a cell and paste only the contents without the underlying formula? This question was asked and answered several years ago but perhaps Numbers has changed. There no longer appears to be a Paste Text Only option in the Edit menu. I have cells that either contain formulas or are hotlinks. I only want to paste the numbers or the text, not the logic. Any suggestions?
1927 4

11 replies

There are no replies.

Copy formula in cell without copying results in that cell

Welcome to Apple Support Community

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

Learn more Sign up