Forum Discussion

Copper Contributor

Sep 27, 2020

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...

excel

Dave_Henricus

Copper Contributor

Sep 27, 2020

Abiola1

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

SergeiBaklan

Diamond Contributor

Sep 28, 2020

Dave_Henricus

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.