How To Lock Cells In Excel Spreadsheet - YouProgrammer

How To Lock Cells In Excel Spreadsheet

One of the most powerful features of Microsoft Excel is that users can lock cells or the whole spreadsheet easily. We can even password protect the sheet cells so that no one can change the values of the cells. This is very important feature nowadays as if you’ve left a spreadsheet opened on your computer, anyone can change the values inside the spreadsheet resulting in the serious loss. In fact, if you use Excel to calculate and show the salary, sales, attendance etc. data then it’s necessary that you should lock your spreadsheet so that unauthorized person can’t change the values. In Excel, we can either lock the complete spreadsheet or can lock a single cell. It’s very useful because not all users want to lock the complete spreadsheet and not all users want to lock a single cell. Hence, both the features are available inside the Excel. In this article, we’ve shown how to lock cells in Excel and how to lock spreadsheet in Excel.

The process of locking a single cell or an entire spreadsheet is almost the same but in order to lock a single cell, you need to follow some more steps. In fact, locking the cells also saves us from the accidental change in the values or deletion of some cells. If we’re working with very important data then the accidental change in values will result in the huge loss. In this case, we can protect the spreadsheet without the password. But, to prevent the unauthorized access, we can simply set the unlocking password. Excel is really a very useful spreadsheet software and you should check out an article on how to merge cells in Excel which will be useful to you in many ways.

How To Lock Cells In Excel

We’ll be showing two methods in this article. One is for locking the entire spreadsheet and another is locking a single cell. We’ve shown the detailed process down below n this article with pictures so that you can follow the process easily.

Lock All Cells In Excel Spreadsheet

  1. Open the existing Excel spreadsheet or create a new one.
  2. Now, press Ctrl+A or press on the arrow icon.
  3. Select the Review tab and then choose Protect Sheet option.lock cells in excel
  4. A new dialogue box will appear, enter the unlock password and confirm the entered password. (Leave the password field blank if you don’t want to password protect it).how to lock cells in excel

Once you’ve entered the password, the spreadsheet will be locked and unauthorized users can’t access it without the password.password protect spreadsheet excel

To Unlock Cells In Excel Spreadsheet:

Later you might want to unlock the cells to edit the data inside them. Follow the guide below:

  1. Open the password protected spreadsheet.
  2. Click on the Review tab and then choose Unprotect Sheet.
  3. If you’ve entered the password, enter it again to unlock it. If you haven’t used the password to lock it, the spreadsheet will be unlocked without the password.password protect cells excel

This is the complete process to lock and unlock all the cells in Excel. Now, to lock a single or few cells in the spreadsheet, follow the process given below.

How To Lock A Single Cell In Excel

The process is little tricky. First, we need to select the cells we don’t want to unlock and then we’ll change their format settings. Read the steps:

  1. Open the Excel Spreadsheet.
  2. Press Ctrl on your keyboard and select the cells you don’t want to unlock.
  3. Once you’ve selected all the cells not to unlock, Right Click>Format.selected cells to be locked
  4. A new dialogue box will appear and then click on Protection tab and uncheck the Lock option.change the protection settings
  5. Press OK to close the dialog box.
  6. Now, again press Ctrl+A and click on Review>Protect Sheet.
  7. Enter the password if you want to password protect the password if you want to password protect the cells or leave it blank if you just want to lock the to lock cells in excel
  8. Once you’ve entered the locking password, the selected cells will be locked.

We now hope that you’re able to lock cells in Excel. We’ve shown the complete guide on how to lock cells in Excel. We hardly recommend you to remember the password you’ve used to lock the cells otherwise you’ll lose your access to the spreadsheet resulting in the loss. If you’re having the problem in locking the cells in Excel then comment down below. We’ll reply you soon with a solution

Leave a Reply