View Single Post
  #3   Report Post  
jahoobob
 
Posts: n/a
Default how do i lock cells in exel


Format the cells you want to protect to locked protection and then
protect the worksheet.
You may have to unlock all the cells first:
Select the entire worksheet by left clicking the square in the corner
between 1 and A. Select Format, then the Protection tab, then uncheck
Locked and then OK.
Highlight the cell(s) you want to protect and repeat the above Format
step but make sure the Locked box is checked.
Select Tools, Protection, Protect Sheet, make sure the top box is
checked, enter a password, make sure the first box under the password
is not checked and the second one is and then OK.
To edit the protected cells:
Tools, Protection, Unprotect worrksheet, enter password.
Hope this helps,
Bob
funbox Wrote:
have done a spread sheet and want to lock multiple cells so they cant
be
typed over



--
jahoobob