• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 62
  • Last Modified:

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?
Josh Ehlers
Josh Ehlers
2 Solutions
Rob HensonFinance AnalystCommented:
Yes there is.

In the format cells pop up there is a tab across the top for Protection. One of the options on this tab is Locked.

The default is for cells to be locked so you have to select those that you don't want locked and remove the locked setting. Alternatively, select all and Unlock and then select only those you want locked and change the setting to locked on those.

The Locked setting will only be enforced when the sheet is protected. After setting the Lock on those cells that you want locked, go to the Review tab and select Protect Sheet. The password is optional; if this is only to prevent accidental deletion then it might not be required.

There are various other options which can be set when the sheet is protected but sounds like you want the default which will already be selected.
ITSysTechSenior Systems AdministratorCommented:
Take a look at this first video it explains the process of locking a cell (assuming your on Excel 2016). Linky
KoenChange and Transition ManagerCommented:
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)
NorieVBA ExpertCommented:
Yes you can lock specific cells.

1 Select all cells.

2 Goto Format and deselect Lock Cells, now all cells are unlocked.

3 Select the cells you want to lock.

4 Either right click and select Format Cells... goto the Protection Tab and check Locked.

4 Or, goto Format and select Lock Cell.

5 Goto Format>Protect Sheet.
Josh EhlersAuthor Commented:
That worked perfectly, thanks you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now