Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2003 lock cells 1

Status
Not open for further replies.

brendan4

IS-IT--Management
Jun 11, 2008
1
US
I am constructing a survey in excel and I need to lock certain cells so that the survey group can’t change them. How can I do this?
 
Any cells formatted with protection as locked ( by the way, that is the default ) will be locked when you protect the sheet ( Tools/Protection/Protect Sheet ). So, format the cells you want as changeable as unlocked before applying sheet protection.

Cheers, Glenn.

Beauty is in the eye of the beerholder.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top