• Home  / 
  • Excel
  •  /  How to unlock or lock cells in excel- Single or multiple

How to unlock or lock cells in excel- Single or multiple

Blog 5 - protect few cells

Objective of this article:

In Microsoft excel 2007 or later version, we want to protect few cells only in a worksheet, then how to do it?

Solution: There are two situations to lock cells in excel depending on these reasons.

  1. If You Want the Majority of Cells Locked
  2. If You Want the Majority of Cells Unlocked

They are explained as follows:-

A. If You Want the Majority of Cells Locked 

  1. Select the cells that you want to remain unprotected. To select nonadjacent (noncontiguous) cells, hold down CTRL and click the cells that are to remain unprotected.

lock cells in excel

(Image 1)

  1. On Excel 2007 or later, make right click on any selected cell and select FORMAT-CELL, and then click Protection

Click to clear the Locked check box and click OK.

lock cells in excel

Protect sheet

(Image 2)

  1. In Excel 2007 or later, click the Review tab, and click Protect Type a password if you want one, and then click OK.
lock cells in excel

Password protection

 

(Image 3)

B.  If You Want the Majority of Cells Unlocked

To leave the majority of the cells on the worksheet unlocked, follow these steps:

  1. Select the entire worksheet by clicking the Select All button (the gray rectangle in the upper-left corner of the worksheet where the row 1 and column A headings meet), or by pressing CTRL+A.
lock cells in excel

Select all cells of sheet

(Image 4)

  1. On Excel 2007 or later, make right click on any selected cell and select FORMAT CELL, and then click Protection.

Hey I #justgotthis good read on

 Tweet this article with friends!

Click to clear the Locked check box and click OK.

lock cells in excel

unlocking cells in format cell

(Image 5)

  1. Select the cells that you want to protect. To select nonadjacent (non-contiguous) cells, hold down CTRL and click the cells that you want to protect.

Return to the Format Cells dialog box, and then click the Protection tab. Click to select the Locked check box, and then click OK.

lock cells in excel

Password protection

(Image 6)

  1. In Excel 2007 or later, click the Review tab, and click Protect Sheet. Type a password, if you want one, and then click OK.
lock cells in excel

Password protection

(Image 7)

To get better insights on excel check out these sections

Advanced Excel Tutorials

Free online Excel courses

Comment below regarding Userform

About the author

Sagar Doshi