Jan 30 2022 06:45 AM
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 preference that must be turned on for this to work? Here is a screenshot of my paste special options, there is only paste text only available to me. Thank you in advance for any help.
Jan 30 2022 06:57 AM
@Rick_Adams Can you show what you are copying?
Jan 30 2022 07:05 AM
Jan 30 2022 07:07 AM
@Riny_van_Eekelen Hello and thank you for your reply. I am trying to copy the underlying table in the original screenshot, here it is again.
Jan 30 2022 07:13 AM
Jan 30 2022 07:19 AM - edited Jan 30 2022 07:22 AM
@Rick_Adams Don't know. On a Mac myself. When I copy an entire table and select the Paste button, I get all the Paste options. And when I choose Paste Special I get this:
Jan 30 2022 07:25 AM
SolutionJan 30 2022 07:25 AM
Solution