How You Can Lock and Unlock Cells, Formula in MS Excel?

If the user wants to lock the cell, just to make it protected so that nobody can make changes in the cell. Then you must read this blog, in which you will learn how to lock and unlock the cells in MS Excel. If the customer need help, then they can visit to the site of MS Office via www.office.com/setup.

click here to download

Lock Cells in Excel Spreadsheet:

For this, you should open the Excel file and then you have to click on the Review tab. After this, you should click on the Protect Sheet. Now, a Protect Sheet window will display on your screen. At this point, you should enter a password just to protect the Excel sheet. Now, you should click on the OK button to enable the protection.

Now, you will see that your Excel sheet is protected from any types of modifications. And nobody can edit any of the locked cells.

If you want to unlock the cells, then you should first unprotect the sheet by going to the Review tab and then choose “Unprotect Sheet,” and after this, enter the password, if needed.

Lock Individual Cells in Excel Worksheet:

First, you should choose all the cells which you don’t want to be locked. This means, all the cells selected by you can be edited even when the spreadsheet is protected. Now, you should right-click on your selection, and then choose Format Cells and then you should go to the Protection tab. Or you can also go to the Home tab and then click on the expansion icon and then choose Format Cells window and then click on Protection tab. After this, you should unmark the “Locked” and then you should click on OK button. Then, you should go to the Review option and then click on Protect Sheet and then hit the OK button.

Lock Cells With Excel VBA:

First, you should choose entire cells in your Excel spreadsheet. Then, you should go to the Home tab and then go to cells. Now, from this cell section you should click on the Format option and then just choose the format cells option. It will open a Format Cells dialogue box and in this dialog box, you should click on the Protection tab. Then, just un-select the option Locked. Now in your Excel file, the name of your sheet displays. You just have to make a right click from your mouse and then choose the View Code. It will open Microsoft Visual Basic for Applications dialogue box. Then in the opened white sheet, you should type the code. Now, in the written code, you should select the data range. When you enter the complete code, you should go to the Debug. There you will find a Run Sub/UserForm (F5) option and just click on it. Here, you will see that your Excel worksheet will open with a password window. At this point, you should write same the password which is allotted in the VBA code. When anyone tries to make changes in the specific cells of the Excel, then this will show you a warning message “you can’t edit the cells as it is protected”.

Unlock Specific Cells in a Worksheet:

You should select the locked cells which you want to unlock or modify. Then, just click on the “Home” tab and then click in the “Cells” area, and after this, just choose “Format” and then select “Format Cells“. Now, you should go to the “Protection” tab.  At this point, you should unmark the box which is next to “Locked” to unlock the cells. And then you should click on the “OK“ button.

Lock Formulas In Microsoft Excel:

First, you should unlock all the cells. Then, you should select all the cells which contain formulas. For this, you can use Go To Special option. Now, you should Lock these selected cells. After this, you should protect the worksheet. www.office.com/setup

Hide Formulas In Excel:

You should click on Control + A key from the keyboard just to select all the cells which is present in the worksheet. Then, you should go to the Home and then click on the Find & Select option. Now, from the drop-down menu you should select Go to Special. After this, you should select Formulas from the Go to Special option. Now, you should click on the OK button. Here, all the cells which contains the formulas get selected. At this point, press the Control + 1 to open the format cells dialog box. At the end, Format the Cells dialog box opens and then you should go to the Protection tab. Now, mark the Hidden option and then just click on the OK button.

But if the user needs any support, then they can contact to the expert through office.com/setup.

Leave a Reply

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