Excel help !

Clinth

Senior member
Dec 11, 1999
569
0
0
How do you make a certain range of cells read only? I'm trying to make the cells and the function protected so other people don't get in and mess up the calculations.

Thanks for the help.
Clinth
 

thEnEuRoMancER

Golden Member
Oct 30, 2000
1,415
0
71
First select all the cells that you don't wish locked (read-only), press right mouse button and select "Format cells". Go to "Protection" tab and uncheck "Locked".
Then go to menu Tools/Protection and select Protect Sheet. Password is optional.
All the cells you haven't unlocked before will be locked now.