You may refer to the suggestions from the below Microsoft article and check if it helps. It helps you to prevent accidental deletion or to stop someone else from wrecking your data. After clicking on it a dialogue box of Unprotect sharing will come up. Answer: First, you'll need to un-protect all of the cells on your sheet. This is how you can lock one or more cells in your Excel sheets.
How to unlock cells in Excel unprotect a sheet To unlock all cells on a sheet, it is sufficient to remove the worksheet protection. Click on top of the excel file where Protect and Share Workbook Legacy is written. Protection options in the Protect Sheet dialog box. To make sure the visual display of Scroll Lock is enabled, right click the status bar. How to unlock certain cells on a protected Excel sheet In the first section of this tutorial, we discussed so that no one even yourself can edit those cells without unprotecting the sheet.
By default, the locked cells can be selected, but you can change that in the protection options. Selecting the Protect Sheet command makes it impossible to make further changes to the contents of any of the locked cells in that worksheet, except for those options that you specifically exempt in the Allow All Users of This Worksheet To list box. For that select the cells you want to unlock, right-click on the selected cells. Step 2: Now, select all the cells that contain formulas. I am having difficulty locking specific cells in a formula laden worksheet in Microsoft Excel 2016. Locking cells in an Excel spreadsheet is a two-step process. In case, you want to lock all the cells in a worksheet or protect a specific cell and allow some cells of the excel file to be changeable then you can also do this.
Thankfully, Microsoft and earlier versions let you lock cells to protect them from being modified on. Then all the cells get locked as you required. As mentioned above, all cells are locked by default when you protect the sheet. This article provides you the different techniques of how to lock cells in Excel. On the Home tab, in the Cells group, click Format, and then click Format Cells.
Select the password on Password to unprotect sheet. But if you unfortunately forgot the opening password, Microsoft cannot retrieve it. Luckily, Microsoft Excel 2016 and other of its earlier versions allow you to lock cells and prevent them from being modified. By default all cells are locked. The Scroll Lock setting determines what happens when you use the Arrow Keys in Excel.
This means that the cells are ready to be locked when you protect the workbook or worksheet. Like, you have created an entire years surveillance data of the company and wanted your juniors to mark their remark on it. When Scroll Lock is off the default setting , the Arrow Keys allow you to navigate and select different cells within a worksheet. However, you can specify whether a cell should be locked or unlocked in the cell's format properties. An option list will pop out, select Format Cells.
The procedure of adding them is given below. You can lock all the cells in a worksheet or specific cells, allowing some parts of the spreadsheet to be changed. How to Lock All the Cells in an Excel Worksheet By default, when you protect a sheet or workbook, all of the cells will be locked. This is how it looks like: Users are expected to enter their data in cells B2:B9, and the formula in B11 calculates the balance based on the user's input. Now that your boss is done with the workbook, you can lock these cells.
Step 6: To unprotect the sheet, go back to the Review tab and under Changes group click on Unprotect Sheet. Protip: If you want to quickly lock or unlock cells that aren't next to each other, you can use a keyboard shortcut. My name is Mitch Bartlett. Tip: It's a best practice to unlock any cells that you may want to change before you protect a worksheet or a workbook, but you can also unlock them after you apply protection. Additionally, the program selects both the Select Locked Cells and Select Unlocked Cells check boxes in the Allow All Users of This Worksheet To list box below.
Locking cells will ensure their functions remain intact when sharing spreadsheets. Sometimes you even want to protect the entire sheet from being changed. Another dialogue box of Confirm Password will come up. How to Lock Specific Cells in a Worksheet With the help of above-discussed methods, all cells will get locked by default as it protects the entire sheet. Locking cells, columns, and rows in excel give you the freedom to protect your data. Another dialogue box of Confirm Password will come up. At last, Format the Cells dialog box, and then go to the Protection tab.