Please can someone remind me how to protect a formula in Excel?

[mckenzie]

I have created a spreadsheet for calcuating a 12 month cashflow for the business and marketing element of my college course. My tutor has asked for a copy of the template for giving to his next batch of students. I'd like to protect the formulas so that they dont get overwritten by mistake but I can't remember how to do it!

TIA

Control-A to select all cells in sheet.

Format -> Cells -> Protection -> Locked -> untick box

Select cells to protect

Format -> Cells -> Protection -> Locked -> tick box

Tools -> Protection -> Protect Sheet

thansk PandL - that's what i've been trying to do but I, so far, can only protect the whole sheet and not just the cells that I want to protect so i'm still not getting it right. I've been highlighting the cells with the formulas in and sure enough after follwoing the process mentioned, if i then try to overwrite them it asks me for the password but if I also try to enter some values in the clear cells it also asks me for the password. So I'm doing something wrong! I have 2007 version - is it slightly different I wonder?

Did you do the first bit where you unlock all of the cells before locking the ones you want to protect? The default state of any Excel cell is "Locked" so you need to make sure that any you don't want locked are set to unlocked before you protect the sheet.

thanks again pandl. Have to just do the pre-school run now. will be back later and do 'exactly' as you said this time

thanks for your help PandL - sorted now.