How To lock Cells in Excel

In this article, I want to show you How to Protect Cells in Excel. You have work hard and you want to make sure someone you share it with not intentionally change cells that should not be changed. Thankfully, Microsoft Excel 2016 and older Versions let you lock cells and protect them from being modified in Window 10. You can all the cells in a specific cells, permitting some part of the spreadsheet to be changed.

Here are some ways How to Lock all Cells in Excel Worksheet;

By default, if you protect cells in a sheet or workbook, all cells will lock. It means they cannot be deleted or reformatted.

  • Go to the Review tab
  • Press on Protect Sheet. In the Protect Sheet, enter a password that is required for unprotected the sheet ( its optional)
  • Click Okay

Lock Specific Cells in an Excel:

There may be times when you want to lock some cells from being changed but still permitted users to adjust other cells. For instance, in an inventory list, you may allow unit price and stock quantity, but not the item ID,s, description or names. As above mentioned, all cells are locked when you protect the sheet. However, you can choose some cells should be locked or unlocked.

You can also read: How to take screenshot on windows 10

  • choose all the cells you want to be lock.
  • Right-click on your selection, choose Format cells, and press on the Protection tab.
  • Uncheck ”Locked” and press Ok.
  • Navigate to Review> Protect Sheet and click Ok to protect the sheet. That locking specific cells wont take effect until you protecting the sheet.

Lock Specific Cells in Google Sheets:

how to lock cells in excel
  • 1. Right press on the cell that you want to lock
  • 2. Press on Protect Range option
  • 3.then click on Add a sheet or range
  • 4. Enter detail for the cell you want to lock
  • 5. In Range option, you can see selected cells reference. You can change if you want.
  • 6.Press on the Set Permission button
  • 7. In the Range Editing Permission, select Only You option
  • Press Done

You may also like...

Leave a Reply

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