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

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?