How to Lock or password protected specific cell in excel 2010 [Solved/Closed]

Report
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
-
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
-
Dear all:

Hope you are fine.

How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell.

Please help me to solve the following problem.

Thanks and regards,

Biswajit

1 reply

Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
440
Hi Biswajit,

There are 2 steps involved.

1. Letting Excel know which cell needs to be blocked. This is done by going to the final tab of "Cell properties" (Ctrl+1). By default all cells are blocked, so the fastest way would be to select all cells (Ctrl+a) and uncheck the blocked box. Then select the cell you want to block and check the blocked box.

2. Protecting your sheet. Go to the "Review" tab to find the option to protect your sheet.

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2905 users have said thank you to us this month

Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014

Hi Trowa,

Thanks a lot for replying to me.

Would you like to tell me step by step of this procedure please?

I have tried a lot but failed.

Thanks and regards,

Biswajit
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
440
Hi Biswajit,

I thought I gave you a step by step way to do this.
If you want to use this strategy then let me know what is not working for you; blocking/unblocking cells or protecting your sheet.

If the value in the cell you want to block is always the same, then you can also use "data validation" which can by found in the "Data" tab.
In the "Allow" dropdown list, choose the bottom option, which will allow you to enter a formula.
If cell A1 is only allowed to contain the phrase "ABC" then use the formula:
=A1="ABC"

Let me know where you get stuck.

I could provide pictures to show the steps, but I'm using a Dutch version, so I'm not sure if it would be helpful to you.

Best regards,
Trowa
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
>
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020

Hi Trowa,

Hope you are fine.

Thanks a lot for giving me instructions which are really helpful. I have solved the problem according to your instructions successfully.

Again thanks.

Regards,

Biswajit