Excel protect a column and a cell
Closed
yarimabu
Posts
3
Registration date
Friday March 7, 2014
Status
Member
Last seen
March 7, 2014
-
Mar 7, 2014 at 07:18 AM
Blocked Profile - Mar 7, 2014 at 09:27 AM
Blocked Profile - Mar 7, 2014 at 09:27 AM
Related:
- Excel protect a column and a cell
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
OK, there are multiple steps, and I have some picture to support the actions.
So step one is-mark the row, column, or cell to be hidden or protected, right click over what you wish to protect and select "FORMAT":
![](https://img-16.ccm2.net/goG73ZNL7Dw8G3BFCfeopqrft3I=/fa19b2c7e6ec4f629a1ba1e25c185151/ccm-ugc/N20iLiNy-cellproperties-s-.png)
Next step is to mark it as protected.
![](https://img-16.ccm2.net/Fgd7fbWZR4LqMJLa3nwUmEkjyrA=/440x/29308fe167874dccb78ce35857a51d52/ccm-ugc/1OEwIgvp-lockedcells.png)
Next step is to secure the page. So you will need to assign a password-write it down, as we do not support FORGOTTEN PASSWORDS!
![](https://img-16.ccm2.net/fahSPTYTwHRFBX903QynUZTd_r4=/440x/eee96b8e707f44ff94383854c83a3b3d/ccm-ugc/RvVExsYJ-permissions.png)
And now lock it. This is the actual step to assign the password.
![](https://img-16.ccm2.net/oUeuue8pGNO5Vr4ewJJe178y1lk=/440x/a5a9cef2708d4ca8a4f0a8c4511ecfa7/ccm-ugc/OzthEo8X-lockit.png)
I hope this helps.
Have FUN!
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
So step one is-mark the row, column, or cell to be hidden or protected, right click over what you wish to protect and select "FORMAT":
![](https://img-16.ccm2.net/goG73ZNL7Dw8G3BFCfeopqrft3I=/fa19b2c7e6ec4f629a1ba1e25c185151/ccm-ugc/N20iLiNy-cellproperties-s-.png)
Next step is to mark it as protected.
![](https://img-16.ccm2.net/Fgd7fbWZR4LqMJLa3nwUmEkjyrA=/440x/29308fe167874dccb78ce35857a51d52/ccm-ugc/1OEwIgvp-lockedcells.png)
Next step is to secure the page. So you will need to assign a password-write it down, as we do not support FORGOTTEN PASSWORDS!
![](https://img-16.ccm2.net/fahSPTYTwHRFBX903QynUZTd_r4=/440x/eee96b8e707f44ff94383854c83a3b3d/ccm-ugc/RvVExsYJ-permissions.png)
And now lock it. This is the actual step to assign the password.
![](https://img-16.ccm2.net/oUeuue8pGNO5Vr4ewJJe178y1lk=/440x/a5a9cef2708d4ca8a4f0a8c4511ecfa7/ccm-ugc/OzthEo8X-lockit.png)
I hope this helps.
Have FUN!
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon