How You Can Lock Formulas In MS Excel?

Microsoft Office is the software which includes many applications like MS Word, MS Excel, MS PowerPoint and MS Access etc. All these applications perform different functions like formatting, editing, creating text documents; create spreadsheets and making professional presentation etc. You can install this software through www.office.com/setup. This software provide user friendly interface and makes the work of the people easy. It is recommended that no other software has the ability to compete with the application of this software. In this blog, you will learn how to lock the formulas in MS Excel.

ms-office.us.com

Steps to Lock Formulas In MS Excel:

  • 1: Select All the Cells and click Unlock it.

For this, first you have to select all the cells in the worksheet or you can use Control + A key altogether. Then you have to hold the Control key and then press 1. This will open the format cells dialog box. Now, in the format cells dialog box, you have to select the Protection tab. Then you have to uncheck the ‘Locked’ option and just select OK button.

  • 2: Select All those Cells with Equations:

For this, you have to choose all the cells with equations. Then you have to select all the cells in the worksheet by using Control + A key altogether. Now just go to Home option and in the Editing group, you have to click on Find and Select option. After this, you have to click the drop-down, and then you have to select Go to Special. Now, In the Go To Special dialog box, you have to choose Formulas. And then just click on OK button.

  • 3: Lock Cells with formulas.

The cells with formulas selected, you have to press Control + 1 key altogether. Now in the format cells dialog box, you have to select the Protection tab. Then just you have to check the ‘Locked’ option. At the end, you have to select ok button. sources

  • 4: Secure the Worksheet.                                     

For this, first you have to go to the Review tab. Then you have to click on Protect Sheet. Now In the Protect Sheet dialog box, you have to checked the option ‘Protect worksheet and contents of the locked cells’. You can specify the password also. At the end just click OK button.

Through this way, you can lock formulas in Excel. But if you are still facing any kind of problem then you can call the customer care expert of MS Office through office.com/setup.

read alsoHow to Troubleshoot MS Office Error Code 147-0?

Leave a Reply

Your email address will not be published. Required fields are marked *