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 >
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 >
After copying a cell there is always a value pasted. Usually the "standard" copy-past-action inserts formulas.
Apparantly this standard setting has been changed somehow and I can't figure out how to reset.
Can you tell me how I can copy a cell with a formula into an empty cell in a way that results in both cells containing formulas?
MacBook Pro (13-inch Late 2011), OS X Mountain Lion (10.8.4)
please show a screenshot showing the cell you are copying highlighted AND make sure the formula bar is included
How are you pasting? Using a key combination? a menu item? if so please indicate precisely how you are pasting. Also what part of the world are you located? It must be in a non-english country since you are using the ";" as the argument separator.
Usually I'm using #c to copy and #v to paste. But as it doesn't work I have also tried to copy and paste by means of the menu. But that hasn't worked either.
I'm from Germany by the way, I didn't know that there are different separators in different countries, interesting fact ;-)
can you post a screenshot of your edit menu while in Numbers? Please.
Like this:
Sarah,
I don't have a good answer for you. Copying from a Numbers table and Pasting back into Numbers should retain the formulas, or give you error alarms. There are cases, such as pasting into a TextEdit document, where the conversion to Values is automatic, but that's a special case.
One thing you could try is to change the formatting of your source table to Text before copying. Then after you paste the formulas as text into the destination, you can reconstitute the formulas by changing the cell formats back to what they should be, or Automatic.
Jerry
Hi Jerry,
it works again. I had "copy less" installed - a program to save the "copy-paste-history". And as far as I know it copies plain text. I removed it - and I can copy-paste formulas again.
You gave me a good hint with the TextEdit document, thanks a lot! 🙂
Best
Sarah
Problem solved - thanks for your help!
when copying only values are inserted - how to change this?
