Function problem

Dear Excel Geeks,

 

My problem is probably a minor one, but I am new to excel and the problem drives me nuts. I am using Excel 2008 for Mac, and I am working on a project involving multiple sheets. I have created a new column, just a simple sum of two columns (=C1+D1). My question is how you lock the newly created column, so that when I transfer it into the other excel sheet the function does not follow as well? 

 

Would be very thankful for any answer.

 

All the best,

 

Simon

By: Simon

One thought on “Function problem

  1. andrew walker Post author

    If you just wanted the values you could use paste special and select values. That would remove the formula. Is this what you were after?

Leave a Reply

Your email address will not be published. Required fields are marked *