How to Excel Protect specific cell ?
Ans: Select All (ctrl+a).
Than Right Click > format cells..Enter,
Than Click Protection> Unselect Locked Box than Enter.
Than Select specific cell
Than Right Click > format cells..Enter,
Than Click Protection> select Locked Box than Enter.
Than Click Review Menu>Click Protect Sheet.
Password -------------than ok. again password.........than ok.
Now Your specific cell is locked.
Ans: Select All (ctrl+a).
Than Right Click > format cells..Enter,
Than Click Protection> Unselect Locked Box than Enter.
Than Select specific cell
Than Right Click > format cells..Enter,
Than Click Protection> select Locked Box than Enter.
Than Click Review Menu>Click Protect Sheet.
Password -------------than ok. again password.........than ok.
Now Your specific cell is locked.
No comments:
Post a Comment