How ToTips & Tricks

How to Lock a Excel Cell – Prevent Editing

2 Mins read
How To Lock a Excel Cell - Prevent Editing
How To Lock a Excel Cell - Prevent Editing

Say, you have highly confidential data in an Excel sheet that no other individual must alter at any cost. However, the data must be visible to anyone who intends to view it. In such a case, it is essential to protect your worksheet in such a way that the cells containing your confidential data are locked for editing. This article discusses the various ways through which you can lock a Excel cell and prevent editing on such cells.

  How to Lock an Excel Cell – Prevent Editing


  1. Select the individual cell or range of cells that you want to lock in Excel.
Select cells in Excel
  1. Go to the Home tab from the menu on the top.
  2. Under Home, find the Alignment section.
Home tab in Excel
  1. In the alignment section, click on the small arrow-like icon at the bottom right to expand the Alignment Settings.
  2. This will open the “Format Cells” window. Go to the Protection section in “Format Cells”.
  3. Click on the checkbox next to “Locked”.
Protection tab under Format Cells Window in Excel
  1. Click on OK to close the “Format Cells” window.
  2. Now, you must turn on protection for the sheet or workbook to effectively lock the cells in your sheet.
  3. From the menu above, go to the Review tab.
  4. In the Review tab, find the “Protect” section.
Protect Sheet option in excel
  1. Under “Protect”, click on the “Protect Sheet” button.
  2. In the “Protect Sheet” window, make sure to checkmark the “Protect worksheet and content of locked cells” option. You may or may not enter a password of your choice. Confirm your password when prompted, that is if you decide to enter a password.
Lock an Excel Cell to Prevent Editing
  1. Click on OK. Your cells will now be locked in Excel and cannot be edited or formatted by others

Alternate Way to Lock a Excel Cell 


  1. Select the cell or range of cells that you need to lock.
  2. Right Click on one of the selected cells and click on “Format cells” from the menu.
Format Cells option to lock a cell in Excel to prevent editing of that cell
  1. In the Protection section under “Format Cells”, click on the checkbox before “Locked”.
  2. Click on OK.

Alternate Way to Protect Excel Sheet


  1. Right-Click on the name of the sheet at the bottom.
  2. Select the “Protect Sheet” option from the menu that follows.
Protect sheet option after locking cell in Excel to prevent editing
  1. Further, enter a password of your choice in the “Protect Sheet” window. Although, this is an optional step. Click on the checkbox next to the “Protect worksheet and content of locked cells” option.
  2. Select or deselect the options like “Format cells”, “Format columns”, etc., according to your choice.
  3. Click on OK. Your cells shall be locked in Excel and cannot be edited.

How to Prevent Locked Cells from being Selected


  1. Go to the Review section from the menu at the top.
  2. Under the Review section, you can find the “Protect” category.
  3. Click on the “Protect Sheet” option.
  4. In the “Protect Sheet” window, click on the checkbox next to “Select locked cells”.
Protect worksheet and option to lock Excel cell to prevent editing
  1. Click on the OK button to confirm your changes.

There are many ways through which you can prevent editing of data in Excel like Protecting Sheet, Protecting Workbook, Encrypting Workbook with Password, etc. Similarly, simply locking the cells is an efficient method too. It allows for a more customizable way to ensure protection.

We hope you find the above-mentioned steps to lock an Excel cell easy enough to follow. Are you aware of any other methods to protect the formatting of data in Excel? Do let us know in the comments.

314 posts

About author
Howdy, I’m Varun Sharma. I’m an Engineer & Geek. I am a fan of technology, programming, and entrepreneurship. Also, an artist & full entertainer dose by nature.
Articles
Related posts
GoogleHow ToTips & Tricks

How to Create Resume Templates for Google Docs

4 Mins read
Creating a professional resume is a critical step in landing a job. Employers will be looking for resumes that highlight the most…
How ToTips & Tricks

How to Check How Old Is My Phone

4 Mins read
In today’s fast-paced world, technology advances rapidly, and newer models of smartphones are released every year. However, not everyone can afford to…
GoogleHow ToInternet

How to Sign In with a Different User Login for Gmail

4 Mins read
The creation of E-mail was a revolution in the human world, it changed the way we communicated with each other. Almost everyone…
Intel Newsletter

Get the latest how-to guides, tips and tricks in your inbox.

Leave a Reply

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

×
How ToTips & Tricks

How to Remove Duplicates in Excel