hi,
The default setting for each cell is for them to start locked. So, you first
need to highlight ALL cells in the sheet, right click, choose format, go to
the Protection tab and take the tick out of the Locked box.
Now no cells are locked.
Now you need to select the one cell you want locking.
Hi Roop,
Follow the below steps to protect the cells :-
1) Select the cells that need protection.
2) Right click > Format Cells.
3) Go to Protection Tab
4) Select LOCKED CheckBox. (Locked check box restricts editing of cell)
5) Click OK
6) Go to Review tab (in Excel 2007)
7) Click on "Protec
Dear all
I want to know how i can protect a single cell in my work sheet so
that nobody (else me ) can change that cell's data.
thanks in advance
Roop
--
--
Some important links for excel users:
1. Follow us on TWI
