Link to home
Start Free TrialLog in
Avatar of Josh Ehlers
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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ITSysTech
ITSysTech

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)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Josh Ehlers

ASKER

That worked perfectly, thanks you