Can I lock worksheet reference?
 

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.

Can I lock worksheet reference?
 

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

"Kathleen" wrote:

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.