Excel

How to lock cells in excel

How to lock cells in excel sheet? Having trouble to lock excel sheet and just want to lock the excel sheets so that the excel cell cannot be changed.

Congrats! You came to the best place. We will make you a master in that in just a couple minutes as you read the blog.

How to lock cells in excel

how to lock cells in excel sheet.

So, you have worked on an excel sheets and want to share it. But you are tensed that anyone can change the data available in cells. And all your time spent to make the excel sheet will be wasted.

Then don’t worry, here’s your tutorial which helps you in locking the cells in excel sheets.

So no one change the work done by you on this excel sheet.

So let us first have a look at a video for better understanding on

How to lock cells in excel sheet?

And now as you have watched the video tutorial, here is your text based tutorial. Enjoy reading.

Case 1

If you want to lock the entire cells of the excel sheets and don’t want anyone to change anything in that excel sheets.

Then to lock the entire excel cells of excel sheets follow the following steps :-

  • Go to the Microsoft excel and open the excel sheet.
  • After you have opened it. Navigate to the Review tab.
  • Click Protect Sheet.
  • In the Protect Sheet window, enter a password that’s required to unprotect the sheet (optional) and any of the actions you want to allow users.
Block cell in excel
  • Click OK to protect the sheet.
  • When you or anyone else tries to edit any of the locked cells, this message will come up.
How to lock cells in excel
  • The cells can only be unlocked when the sheet is unprotected (by going to the Review tab again, choosing “Unprotect Sheet,” and entering the password, if required).

If you just want to lock some cells of excel sheets then the CASE 2 is for you. 

CASE 2 

How to lock specific cells of an excel sheet. 

So, for example you have a storage and prepare an excel sheets with product id, stock, and price. So you create an excel sheets now and want to send it to the workers working at your storage.

Then you will be willing that some cells of excel sheets should not be getting changed like the product id cell. And therefore the CASE 1 will not work here.

As the entire excel cells in excel sheet get locked and cant be changed and therefore, 

To lock specific cells of an excel sheet follow the following steps :-

  • Select all the cells you don’t want to be locked.
  • These will be the cells that can be edited even after the sheet is protected.
  • Right-click on your selection, select Format Cells, and click on the Protection tab. (Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells window go to the Protection tab.)
How to block cells in excel sheet
  • Uncheck “Locked” (which is checked by default) and click OK.Go to Review > Protect Sheet and hit OK to protect the sheet.
Block cells in excel
  • Any cells that didn’t unlock under the Format Cells option (step 3 above) will be locked, while the unlocked cells will be editable.

Bonus tip

If you want to quickly lock or unlock cells that aren’t next to each other, you can use a keyboard shortcut.

After selecting a cell or group of cells, use the Format Cells dialog as above to lock or unlock it. Then select your next cell(s) and hit F4 to repeat your last action.

Hope now to know how to lock cells in excel.

To read more tutorials and reviews related to laptops click here.

Some part of this post is referred from laptopmag article.

Leave a Comment

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