![]() |
How do I lock a cell in excel file ?
Hi,
I want to lock few cells which carries formulae, so that data entry person do not make any changes. He or she only enters the data. |
How do I lock a cell in excel file ?
the default setting for cells is locked. However, this is not enforced
until the worksheet is protected. Have you unlocked the cells that you want the user to have access to, then protected the sheet? -- Regards, Tom Ogilvy <Raja; "London" <Raja, wrote in message ... Hi, I want to lock few cells which carries formulae, so that data entry person do not make any changes. He or she only enters the data. |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com