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 date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel if cell is a date ✓ - Office Software Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
1 reply
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":

Next step is to mark it as protected.

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!

And now lock it. This is the actual step to assign the password.

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":

Next step is to mark it as protected.

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!

And now lock it. This is the actual step to assign the password.

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