0
0 Comments

I’ve found a way to copy formulas only in Google Sheets through 

Search and Replace
Ctrl
+ 
H
feature workaround as follows:

STEP 1:

Cells with Formulas to be copied Cells with Formulas to be copied

STEP 2:

Press 

Ctrl
+ 
H
and Tick Also search within formulas Press Ctrl + H and Tick Also search within formulas

STEP 3:

Copy Formulas (formulas only are copied) Copy Formulas (formulas only are copied)

STEP 4:

Select a destination cell/range and paste the clipboard content Select a destination cell/range and paste the clipboard content

STEP 5:

Result: Formulas only are pasted Result: Formulas only are pasted

Please share any way you know to do it with less steps. Thanks a lot for your help much appreciated.

Anonymous Asked question May 13, 2021