Excel - How to lock a specific cell in Excel?

All cells on an Excel worksheet are locked by default, but this only becomes effective when the worksheet is protected.

So you have to take two steps:

First, select all cells that the user should be able to edit.

Press Ctr+1 to activate the Format Cells dialog.

Activate the Protection tab.

Clear the Locked check box.

Click OK.

All cells that you did NOT select will remain locked.

Then, activate the Review tab of the ribbon and click Protect Sheet.

Use the check boxes to specify what the user should be able to do.

At the very least, leave the check box 'Select unlocked cells' ticked.

If you want to specify a password that will be needed to unprotect the sheet later on, enter it (and do not forget it!)

Click OK. If you provided a password you will have to enter it again as confirmation.

Users will now only be able to edit the cells that you unlocked.

The lock a specific cell function doesn’t work in excel.  It can only lock the whole excel sheet.

How to lock a specific cell in Excel?

I’ve just put up a WORD file for you at:-

https://www.mediafire.com/file/yygwt017l9eg2di/lock_a_specific_cell_in_excel_testing_feb_7_2021_1.docx/file

Download the file and open it clicking:-

Enable Editing

 - if necessary.

Go to page 1 of the document and click in:-

Answer 1 to Thomas

 - then do a:-

CTRL

• click

 - to take you to the section called:-

Answer 1 to Thomas

Now follow the step by step instructions there to show you what you have to do to achieve your goal.