Josh Ehlers
asked on
Can you lock cells in Excel
On excel, is there a way to lock certain cells, so the information in them can not be accidentally deleted while allowing the rest of the page to be modified?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Take a look at this first video it explains the process of locking a cell (assuming your on Excel 2016). Linky
all cells are by default in a status locked , but protection is off (disabling the locking).
So to lock cells, do the following.
First select the cells that need to be 'unlocked' (able to change) and right click and select format.
in the tab Protection, uncheck the box Locked for all cell that need to be changed by the user.
then perform a 'protect sheet' or 'protect workbook' to enable the locking. You can add a password to disable them from turning of the protection.
Make sure you remember the password if you set one... (they used to be easy to crack, but with the newer version are quite hard)
So to lock cells, do the following.
First select the cells that need to be 'unlocked' (able to change) and right click and select format.
in the tab Protection, uncheck the box Locked for all cell that need to be changed by the user.
then perform a 'protect sheet' or 'protect workbook' to enable the locking. You can add a password to disable them from turning of the protection.
Make sure you remember the password if you set one... (they used to be easy to crack, but with the newer version are quite hard)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked perfectly, thanks you