View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default Lock specific cell

I cannot get the lock specific cell function below to work:

1. Select entire worksheet by clicking the Select All button
2. Click Cells on the format menu, click the Protection Tab, and clear the
LOCKED check box.
3. Select the cells you want to lock and repeat step 2, but this time select
the LOCKED check box.
4. Go to tools menu, point to Protection, and click Protect Sheet. Then OK.

It locks the entire worksheet instead of the few cells I've locked
individually.