Here are the steps to select all the cells that have formulas: To do this, we need to first select all the cells with formulas. Now that all the cells have been unlocked, we need to make sure that the cells that have formulas are locked. Step 2: Select All the Cells that Have Formulas In the format cells dialog box, select the Protection tab.This will open the format cells dialog box.
![how to lock certain cells in excel 2016 how to lock certain cells in excel 2016](https://www.lifewire.com/thmb/guMYJYZ9sxx8oObUx-pkKz0WNNs=/1366x768/filters:no_upscale():max_bytes(150000):strip_icc()/001-how-to-unprotect-excel-workbooks-4691837-3a97c2e1474c45e8a6a8175b2222307a.jpg)
Use the keyboard shortcut Control + 1 (hold the Control key and then press 1).Select all the cells in the worksheet (use the keyboard shortcut Control + A).Here are the steps to unlock all the cells: To do this, we first need to unlock all the cells and then select and lock only those cells that have formulas in it. If all the cells are locked, and I protect the entire worksheet, it would mean a user can’t change anything.īut we only want to lock (restrict access) to the cells that have formulas in it. While you may find it confusing, bear with me and keep reading.Īs I mentioned, only the cells that are locked as well as protected can truly be restricted.
How to lock certain cells in excel 2016 how to#
Now that I have outlined the steps above, let’s dive in and see how to do this (and more importantly, why we must do this): Step 1: Select All the Cells and Unlock it
How to lock certain cells in excel 2016 full#
You are going through a worksheet full of formulas, and you accidentally hit the delete key, or backspace key, or some other number/alphabet key. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well.
![how to lock certain cells in excel 2016 how to lock certain cells in excel 2016](https://cdn.free-power-point-templates.com/articles/wp-content/uploads/2017/11/Unprotect-sheet.png)
You can easily edit a formula through the formula bar or directly in the cell. Watch Video – How to Lock Formulas in ExcelĮxcel formulas are easy to create and edit in Excel.