Step 1:To lock specific cells rather than the entire sheet, first select the particular cells you want to lock, as shown in the image below: Step 2:Once you have selected the specific cells to lock, right click on those selected cells. From the pop-up menu, chooseFormat Cells. Step 3...
Here’s how to lock or unlock cells in Microsoft Excel 365. Select the cells you wish to modify. Choose the “Home” tab. In the“Cells” area, select “Format” > “Format Cells“. Select the “Protection” tab. Uncheck the box for “Locked” to unlock the cells. Check the box t...
SubUnlockCells()Sheets("Unlock Cells").Cells.Locked=FalseSheets("Unlock Cells").UnprotectEndSub Visual Basic Copy How to Lock and Unlock Cells in Excel Without VBA TheFormat Cellsfeature can be used to lock/unlock cells in Excel, without the need for VBA code. STEPS: Select the desired ran...
The tutorial explains how to lock a cell or certain cells in Excel to protect them from deleting, overwriting or editing. It also shows how to unlock individual cells on a protected sheet by a password, or allow specific users to edit those cells without password. And finally, you will lea...
In this part, we will show you how to lock all cells in a worksheet. By doing this, all cells in the Excel file will become uneditable. How to Lock and Protect All Cells in Excel? Step 1: Select all cells in Excel. You can move the mouse cursor to the top-left corner of the ...
In some cases, you may need to lock or unlock cells based on values in another cell. For example, you need the range B1:B4 to be unlocked if cell A1 contains value “Accepting”; and to be locked if cell A1 contains value “Refusing”. How can you do to achieve it? This article...
In the Format Cells dialog box, in the Protection tab, check the box for Locked. The steps so far would unlock all the cells in the worksheet except the ones that you want to lock (B2 and B3 in this case). Go to the Review tab. In the Changes group, click on Protect Sheet. In...
Unlock the Locked Cells in Excel Locking cells is a feature in Excel to protect the cell’s data from getting edited, modified, or deleted by any user. In Excel, users can lock all the cells with the specific worksheet to protect that entire worksheet cells or only lock the specific cells...
Part 2. How to Lock a Spreadsheet with Data Entry Allowed Method 1: Protecting Worksheet with Editable Ranges Step 1: Select Cells to Remain Editable: Highlight the cells you want users to be able to modify. Right-click on the selected cells and choose Format Cells. ...
Now, it’s time to lock the specific cells. Go to the “Review” tab and select “Protect Sheet” under the “Protect” group. You can set a password to ensure only authorized users can unlock the sheet (this step is optional). Click OK to activate protection. Once done, only the ce...