Forum Discussion
Solved
Copy/Paste Places text not formulas
Hello, I'm so sorry but my version of Excel (16.57 Mac) will not copy and paste the formulas. No matter what I try to do, only the text gets pasted with CTRL-V. What am I doing wrong? Is there a pref...
- Thank you, everyone, for your replies.
I have solved my issue. For anyone else that might come across this post, here is the solution.
If you have Copy 'em installed, this clipboard manager interferes with the copy/paste function in Excel.
In Copy 'em preferences, choose "Ignore Applications..." and add Excel.
This fixed my problem and I can now copy/paste as expected.
Good afternoon, you only show us the paste option but not the paste special option. Normally, in the paste special you have the paste formulas item. Also verify the cells where you paste are not defined as Text (Format cells > Number : category Text)
Regards
Regards
Hello and thank you for your reply. The second screenshot in the original post I thought was the paste special options and in there I only have two options; Unicode text and text. I am trying to copy from one sheet to a second sheet. I am following a training exercise, so there is nothing special going on here. I am trying to copy A1:E5 from sheet 1 to Sheet 2 and I only paste text with CTRL-V. The formulas cannot be pasted and there are no "paste special" options available.