Locking Sheets on Excel 2007

**magneticgravity** · 12-15-2007, 08:45 AM

How do you make it so a sheet is locked, yet a small portion of cells can be changed on Excel 2007.

Something to do with locking/unlocking things, used to be able to do it on Excel XP.

Anyone?

**starguy** · 12-15-2007, 10:40 AM

Originally Posted by magneticgravity

How do you make it so a sheet is locked, yet a small portion of cells can be changed on Excel 2007.

Something to do with locking/unlocking things, used to be able to do it on Excel XP.

Anyone?

Select cells you want to keep unlocked, right click > Format Cells > Protection tab and uncheck Locked option.
Right click on sheet name (sheet tab) and go for Protect Sheet... option and give passward if required.