Microsoft Excel
--
Questions
--
Followers
Top Experts
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?
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
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
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
That worked perfectly, thanks you
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.