How to lock formulas in Excel
There are many ways to protect the Exce file, depending on the needs of each person such as setting a password for the entire Excel file, setting the password for the sheet on Excel so that others cannot edit it, or just setting the security key for the recipe. in Excel file only.
When you set an Excel formula lock, others cannot edit formulas, copy, or delete formulas, but other content can be edited as you wish. The following article will guide you how to lock formulas in Excel.
- Forgot password protected Excel file, what should you do?
- How to break VBA password in Excel
- Password setting tools for PDF files
1. Guide to protecting formulas on Excel
Step 1:
Open the Excel file with the formula to lock the recipe. Select the entire spreadsheet and then click on the Home tab , select Format and click Format Cells .
Step 2:
The Format Cells dialog box appears, click on the Protection tab, and uncheck the Locked option below. Click OK to save.
Step 3:
Go back to the worksheet to mouse in any box, click on the Home tab, then select Find & Select in the Editing group. Click on Go to Special . in the list that appears.
Step 4:
In the Go To Special dialog box, select Formulas and click OK to agree.
Now the cells with the formula on the Excel file will be marked as shown below.
Step 5:
Keep the cells with the selected formula intact. Then click on the Home tab and then choose Format to choose Format Cells . In Format Cells, select Locked and then click OK.
Step 6:
Click the Review tab, then click Protect Sheet .
In the Protect Sheet dialog box, we do the following:
- Password to unprotect sheet: Set the password for the formula. This password will require entering if you want to remove the formula protection feature in Excel.
- Select locked cells: Remove this option.
You will then be asked to re-enter the set password. Finally click OK to save.
When you return to the table, you will not see the formula icon in the formula cell as before. When clicking on the box does not show the formula used. Others will not be able to know and edit that recipe. Areas outside the formula can still be customized as usual.
2. How to unblock Excel formulas
Step 1:
To remove the formula lock feature in Excel click on the Review tab and then select Unprotect Sheet .
Step 2:
Enter the correct formula password that the user has set up before. Click OK.
Finally, the data box uses the formula that appears again and when you click on that box, the formula will appear.
A great way to protect certain content on Excel files, but other content can still be edited as usual. When placing an Excel formula lock, viewers cannot click on the formula box and edit. This will limit the status of editing and deleting formulas on Excel.
See more:
- How to prevent others from copying and editing Word files
- How to set a password for a PDF file?
- 10 ways to recover corrupted Excel files
I wish you all success!
You should read it
- How to set Excel password to secure data file
- 5 useful Microsoft Excel formulas for calculating taxes
- How to create a password protection for Excel sheets
- How to use formula suggestions in Excel on the web
- Forgot password protected Excel file, what should you do?
- MS Excel 2007 - Lesson 6: Calculation in Excel
- Guidelines for importing Chemistry formulas in Excel
- How to enter formula data in Excel
- How to hide formulas in Excel
- How to lock Excel Sheet, set a password for the sheet in Excel
- How to color formula cells in Excel automatically
- Instructions for searching and replacing in Excel tables