Copy Excel worksheets

T

TedDSC

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

Peo Sjoblom

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
 
J

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.
Click to expand...

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
 
Top