View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How can I lock specific cells w/o having to protect entire sheet?

All cells are 'locked' by default, but 'locking' does not come into effect
until you protect the worksheet.

1. Hit Ctl+A to select everything,
2. Right-click then Format Cells, select Protection tab and uncheck Locked.
3. Now select the cells you want to lock. Right-click one of these cells,
Select Format Cells, go to the protection tab and select locked.
4. Now when you protect the sheet (Right click sheet tab), only the cells
selected last are protected.

If this post helps click Yes
---------------
Jacob Skaria


"J. Becker" wrote:

I have designed a worksheet so my boss can enter data from time cards and get
the total hours worked each week by each employee. However, there are
certain cells I don't want anyone to have access to because they must not be
changed, or the worksheet won't do what is needed. So, how do I lock
specific cells only. I want him to be able to use the worksheet to input the
time data, but not access the cells that do the computing because he is not
very computer oriented. Help!!!