How to Lock or password protected specific cell in excel 2010
Solved/Closed
Biswajit-Shaha
Posts
3
Registration date
Wednesday 5 November 2014
Status
Member
Last seen
30 December 2014
-
17 Nov 2014 à 22:24
Biswajit-Shaha Posts 3 Registration date Wednesday 5 November 2014 Status Member Last seen 30 December 2014 - 30 Dec 2014 à 00:47
Biswajit-Shaha Posts 3 Registration date Wednesday 5 November 2014 Status Member Last seen 30 December 2014 - 30 Dec 2014 à 00:47
Related:
- How to lock cells in excel 2010
- Microsoft picture manager 2010 - Download - Image viewing and management
- Excel mod apk for pc - Download - Spreadsheets
- Microsoft office 2010 free download - Download - Office suites
- How to change date format in excel - Guide
- How to lock samsung screen from touch - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
18 Nov 2014 à 12:02
18 Nov 2014 à 12:02
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
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
19 Nov 2014 à 00:37
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
20 Nov 2014 à 11:22
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
30 Dec 2014 à 00:47
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