Copy Excel worksheets

[Guest]

When copying an Excel worksheet from one spreadsheet to another, how does one
copy only formulas and no values ? Using the copy, paste special/formulas
always includes the values.

 

[Guest]

You can't copy only formulas with them not returning what they refer to. If
you mean that you don't want the formulas to refer to the sheet where they
were copied from (if you have =A1 in sheet1 and you want to copy that but
don't want to get =Sheet1!A1) , do an edit>replace, then replace = with let's
say r=, now select the whole sheet and copy, paste intoa new sheet. reverse
the replace with find r=
replace with = in both sheets


Regards,

Peo Sjoblom

 

[Jay]

When copying an Excel worksheet from one spreadsheet to another, how

does one copy only formulas and no values ? Using the copy, paste
special/formulas always includes the values.

Maybe a two-step process will meet your need.

1. Do an ordinary copy/paste, getting both values and formulas.

2. Get rid of the values by doing:
Edit >> Go to >> Special >> Constants
Hit the Delete key