Forum Discussion
Dave_Henricus
Sep 27, 2020Copper Contributor
copy and paste
I want to paste a cell from one excel page to another - the original page has a formula within the cell that I want to copy and paste into the second excel sheet. I have tried all options but none wo...
Abiola1
Sep 27, 2020MVP
Hello,
Kindly check the link below to see whether it answers your question
https://support.microsoft.com/en-us/office/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6.
Cheers
Kindly check the link below to see whether it answers your question
https://support.microsoft.com/en-us/office/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6.
Cheers
- Dave_HenricusSep 27, 2020Copper Contributor
Thanks for your reply but it didn't work.
When I CUT from excel sheet #1 and then opened excel sheet #2, there is no PASTE SPECIAL option.
There is only: PASTE, VALUES and FORMULAS as the only options.
New idea please!
David
- SergeiBaklanSep 28, 2020Diamond Contributor
David, are you on Excel Online?
Anyway, use PASTE to paste formatting and formula; PASTE VALUE to paste only value and PASTE FORMULAS to paste only formulas.