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 .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 1

In the Format Cells dialog box, click the Protection tab , deselect the Locked item, and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 2

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 ).

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 3

In the dialog box Go To Special you select Formulas and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 4

Step 3 : After clicking OK , all the cells containing the formula in Sheet are selected, you just need to click Home -> Format -> Format Cells .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 5

In the Protection tab, click Locked to lock and click OK . If you want to hide the formula, click on Hidden .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 6

Step 4: Select Review -> Protect Sheet (or Home -> Format -> Protect Sheet ) to open the password setting dialog.

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 7

The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 8

Confirm the password and click OK .

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 9

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.

Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel Picture 10

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!