How to lock cells in Excel

How to lock cells in Excel

Trending 6 months ago 55

Dua Rashid

By March 15, 2022 11:41AM

You mightiness privation immoderate cells connected your Microsoft Excel spreadsheet to beryllium protected from editing. You tin easy fastener those cells to forestall them from being rewritten, and you tin fastener each cells oregon circumstantial ones. Let’s instrumentality a look astatine however to fastener cells successful Excel utilizing some methods.

Lock each cells

If you instrumentality this route, Excel locks each cells connected your spreadsheet. However, locking cells has nary effect until you support the spreadsheet too. Here’s however to bash both.

Step 1: Select each cells connected your spreadsheet by pressing Ctrl + A connected your keyboard.

Step 2: Right-click connected 1 of the cells, and past click connected Format Cells. You tin besides property Ctrl + 1 connected your keyboard to execute this step.

Right-click connected  1  of the selected cells and prime   Format Cells.

Step 3: In the model that pops up, look nether the Protection tab to verify that each cells are locked by making definite that the Locked enactment container is checked. Click connected OK.

Make definite   the Locked enactment    container  is checked and property   OK.

Step 4: With each the cells selected, spell to the Review tab from the toolbar astatine the top. Then click connected Protect Sheet.

Go to the Review tab from the toolbar astatine  the apical  and click connected  Protect Sheet.

Step 5: In the model that appears, participate a password to support your worksheet successful the blank abstraction provided. All the selected cells are present locked and protected.

Lock circumstantial cells

You whitethorn privation lone definite cells to beryllium locked connected immoderate of your projects. Here’s however to fastener circumstantial cells successful your spreadsheet.

Step 1: If you person immoderate locked cells from erstwhile locking attempts, you request to unlock each the cells first. Start by selecting each cells by pressing Ctrl + A connected your keyboard.

Step 2: Right-click connected 1 of the cells and click connected Format Cells, oregon conscionable property Ctrl + 1 connected your keyboard.

Step 3: In the model that appears, uncheck the container nether the Protection tab that says Locked. Click connected OK erstwhile you’ve done that.

Step 4: Select the cells that you privation to fastener connected your spreadsheet.

Select the cells that you privation  to lock.

Step 5: Right-click connected 1 of the cells and click connected Format Cells, oregon conscionable property Ctrl + 1 connected your keyboard.

Step 6: In the model that pops up, cheque the container that says Locked nether the Protection tab.

Step 7: The cells you selected are present locked but not protected. Go to the Review tab from the toolbar astatine the apical and prime Protect Sheet.

Step 8: In the model that shows up, participate a password successful the blank tract provided. You person present successfully locked and protected the cells that you selected.

For much Excel tips, cheque retired our articles connected how to password support an Excel file oregon how to person a PDF to an Excel document.

Editors' Recommendations