how to protect different ranges of cells

M

mikehudsonjazzz

How do I protect different ranges of cells in excel when
they are not adjacent to each other? Please give me a step
by step description as this will be my first time
successfully comprehending this proceedure,
 
D

Dave Peterson

Select your first range.
hit and hold the control key and select your second range.
Format|cells|protection tab
check the Locked checkbox.

Remember that locking cells won't do much until you protect the worksheet
(tools|protection|protect sheet).

And depending on how many cells you want locked and how many you want unlocked,
it might be easier to set all the cells one way (locked or unlocked) and come
back and unlock/lock the exceptions.

Ctrl-A (twice in xl2003) will select all the cells.
 
Top