How to Lock or password protected specific cell in excel 2010

Solved/Closed
Biswajit-Shaha
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
- Nov 17, 2014 at 10:24 PM
Biswajit-Shaha
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
- Dec 30, 2014 at 12:47 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Nov 18, 2014 at 12:02 PM
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
Biswajit-Shaha
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014

Nov 19, 2014 at 12:37 AM
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
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Nov 20, 2014 at 11:22 AM
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
0
Biswajit-Shaha
Posts
4
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
December 30, 2014
> TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022

Dec 30, 2014 at 12:47 AM
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
0