Protect a group of cells

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

How do I protect only a group of cells to prevent any change or deletion of
data, and not the entire worksheet? I selected the groups of cells that I
want to protect, and did the protection, but it went ahead and protect
everything in the worksheet, which is what I don't want.

Thank You.
 
Hi
select first all cells for which you want to allow data
entry. -then goto 'Format - Cells - Protection' and
unchek 'Locked'. After this protect your worksheet
 
the default is for all cells to have their locked property set.

Select all the cells and uncheck the locked property.

then select the group of cells and check the locked property

then protect the sheet.
 
Hi Raymond

just a note - its not generally necessary to post to more than one group ...

Cheers
JulieD
 
Especially ones for which your question is not really relevant.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top