how to hide and lock only few selected cells

**gr8ice** · 04-30-2011, 06:53 AM

plz can anyone teach me
1........how to hide only few selected cells
2. ......how to lock only few selected cells

**Rahul Nagar** · 04-30-2011, 06:58 AM

Hello,

First Go to Format Cells Click on Hidden and then Hide the cell and then Protect the sheet.

**gr8ice** · 04-30-2011, 11:12 AM

Originally Posted by Rahul Nagar

Hello,

First Go to Format Cells Click on Hidden and then Hide the cell and then Protect the sheet.

i want to hide only 1 or 2 cells ? or PRotect 1or 2 cells
not a ROW or COLUM ?

**dominicb** · 04-30-2011, 12:07 PM

Good afternoon gr8ice

All cells are locked by default.

Holding down Ctrl, select all the cells you want to be unlocked. Then press Ctrl + 1 and go to the protection tab, make sure the locked box is unticked and click OK.

If you hide the cells, they won't be hidden until you invoke the protection. Even then, the cell will show a value, but the formula cannot be seen.

HTH

DominicB