How To Copy Formulas Only In Google Sheets (without values or formatting) in few steps?
09:16 10 May 2021

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.

google-sheets google-sheets-formula copy-paste