![]() |
Protection of cell in excel
Hi,
I would like to protect some particular coloum, I was using formate cell-protection-Lock, but it was not working, Kindly let me know how do I do it? |
Protection of cell in excel
All cells are locked by default, but locking does not mean anything until
you protect the worksheet from ToolsProtection menu. --First select any cells that a user is allowed to change --Hit Ctrl+1 and go to the 'Security' tab to unlock these cells. --Go to Tools-Protection-Protect Sheet, and you can assign a password (optional) If this post helps click Yes --------------- Jacob Skaria "Sanjay Sharma" wrote: Hi, I would like to protect some particular coloum, I was using formate cell-protection-Lock, but it was not working, Kindly let me know how do I do it? |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com