Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel
Use Excel to process and calculate data to help you work more efficiently. But when sharing data with others, you don't want to be edited by other formulas. The following article will help you know how to lock formulas in Excel, you track it!
Step 1: Open the sheet containing the formula to lock, select all the sheets with Ctrl + A key combination . Then right-click and choose Format Cells .
In the Format Cells dialog box, click the Protection tab , deselect the Locked item, and click OK .
Step 2: You can press Ctrl and manually select the cells containing the formula to lock, or if you want to select all the cells containing the formula in the sheet, then select Home -> Find & Select -> Go to Special (or Ctrl + G and select Special ).
In the dialog box Go To Special you select Formulas and click OK .
Step 3 : After clicking OK , all the cells containing the formula in Sheet are selected, you just need to click Home -> Format -> Format Cells .
In the Protection tab, click Locked to lock and click OK . If you want to hide the formula, click on Hidden .
Step 4: Select Review -> Protect Sheet (or Home -> Format -> Protect Sheet ) to open the password setting dialog.
The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet and click OK .
Confirm the password and click OK .
So you locked the formulas in the sheet, to unlock you go to Review -> Unprotect Sheet (or Home -> Format -> Unprotect Sheet ) then enter the password into the Unprotect Sheet dialog and click OK to Unlock recipe.
The article on detailed instructions on how to lock formulas in Excel, you just need to follow the steps to lock the formula as you like. Good luck!
You should read it
- How to hide formulas in Excel
- How to lock formulas in Excel
- How to delete quick recipe on Excel
- How to Copy Formulas in Excel
- MS Excel - Lesson 5: Excel formulas and functions
- Guidelines for importing Chemistry formulas in Excel
- Instructions on how to copy formulas in Excel
- How to create an Excel formula in Notepad ++
May be interested
- Lock one or more data columns on Excel worksheet - Freeze data in Excelto lock one or more data columns in excel worksheet, you do as follows: open the sheet containing the data columns to be locked, then select all sheets by pressing ctrl + a. right-click and choose format cells ...
- Lock a range of data on Excel spreadsheetsafter you have finished processing data in excel spreadsheets, sometimes for some reason you do not want others to edit the data of a range of data in excel spreadsheets.
- Collection of the most beautiful cover templateshere share the beautiful cover template in word for you to choose.
- Round a number in Excelthe following article shows you how to round decimal places after commas in excel.
- How to draw pictures and diagrams in Wordmicrosoft word not only supports you to edit documents but also supports you with many features, it provides us with drawing tools and drawing diagrams easily and conveniently.
- How to split 1 cell into 2 cells in Excel - Split cells in Excelhow to split 1 cell into 2 cells in excel - split cells in excel. depending on different purposes, you want to split a cell into two cells to enter two different data in one cell and still be able to calculate normally as other cells.