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 EhlersAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
0
ITSysTechSenior Systems AdministratorCommented:
Take a look at this first video it explains the process of locking a cell (assuming your on Excel 2016). Linky
0
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)
0
NorieAnalyst Assistant Commented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Josh EhlersAuthor Commented:
That worked perfectly, thanks you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
REST

From novice to tech pro — start learning today.