Can I lock worksheet reference?

K

Kathleen

I want to be able to move a line off of one worksheet and not have the
formula on another follow it. I understand locking a row, column or cell
reference with a $ sign, but what about the reference to a particular
worksheet.
 
J

JR

Try this... "Copy", "Paste Special", then select "Values" in the dialog box
that pops up.
 
Top