In 2003 and 2007 it's about the same

The basic answer is that you lock all cells then unlock the ones you wish to
be editable. The protect the worksheet.

Format cells - protection tab - tick locked - ok

then highlight all editable cells and follow the above procedure but untick
the locked box - ok

then format cells - protect sheet - create password when prompted - ok

a bonus to this is that when you want to move to the next editable cell -
hit the tab key and it will ignore the locked cells

Check out the MS help



"Mitesh Hirani" wrote:

How do i lock selected cells in excel so that it can be viewed but not
changed....
Maybe changed after putting passord or something........