Running Into Issues in Shared Excel Sheets? Learn How to Lock Cells

Ever left one thing completely effective and got here again to a complete catastrophe? Any pet proprietor will in all probability say, “sure.”

At work, the identical can occur when collaborating on a shared doc. It is often an unintended keyboard stroke that does it. Except it is achieved by your cat, during which case, it isn’t unintended – it is undoubtedly sabotage.

Whereas a mistake like that is comprehensible, it may be irritating and time-consuming to repair. When engaged on shared Excel sheets, you may forestall these mishaps altogether by locking cells and defending your worksheets.

Download 9 Excel Templates for Marketers [Free Kit]

Whether or not you are engaged on an upcoming report or planning out subsequent quarter’s price range, learn to forestall anybody from altering or deleting vital data on an Excel doc.

Are you able to lock cells in Excel?

Sure, you may lock cells on Excel by following just a few easy steps. Once you lock a cell in Excel, you limit customers from making modifications to your sheets. It is notably useful when engaged on a undertaking that entails a number of workforce members.

As an example, as an instance you are the advertising director and you’ve got requested every channel lead (e mail, web site, social) to report their quarterly numbers for an upcoming assembly.

You would not need somebody by chance deleting vital data, or altering formulation or conditional formatting earlier than consulting with key stakeholders. This course of ensures that solely pre-approved customers can edit the cell, which can prevent a headache sooner or later.

One other methodology is locking your formulation cells in order that the numbers populate appropriately. Leap to that part right here.

Easy methods to Lock Cells in Excel

1. Choose the cell(s) you wish to lock.

How to Lock Cells in Excel

2. Click on on the “House” tab of your Excel sheet.

How to Lock Cells in Excel step 1

3. Click on on “Format,” positioned on the correct facet of the display.

How to Lock Cells in Excel step 2

4. Scroll down and click on on “Lock Cell.”

How to Lock Cells in Excel step 3

When you full these steps, your cells will probably be locked however can nonetheless be edited. To make sure the cells aren’t editable, you will even have to guard your worksheet. Discover these steps within the subsequent part.

How To Shield a Worksheet in Excel

1. As soon as you’ve got locked your cells, click on on the “Evaluation” tab.

How To Protect a Worksheet in Excel step 1

2. Click on on “Shield Sheet.”

How To Protect a Worksheet in Excel step 2

3. Choose which permissions you would like to permit on the sheet, then click on “OK.” You may as well add a password for extra safety.

How To Protect a Worksheet in Excel step 3

Notice: If you happen to do not add a password, any consumer can click on “Unprotect Sheet” to make modifications to the sheet. Once you add a password, solely these with the code can accomplish that.

4. Verify that your cells are locked by searching for the “Unprotect Sheet” icon within the toolbar.

How To Protect a Worksheet in Excel step 4

You may as well double-check that your worksheet is protected by making an attempt to put in writing one thing within the locked cells. It’s best to get this alert.

How To Protect a Worksheet in Excel step 5

Easy methods to Shield Particular Cells in Excel (& Get a Shortcut to Lock Cells)

1. Choose the cells you wish to lock then press Ctrl+Shift+F (Home windows) or Ctrl + 1 (Mac) to open up the “Format Cells” field. Then, click on on the “Safety” tab.

How to Protect Specific Cells in Excel step 1

2. Choose the “Locked” field and click on “OK” on the underside proper to complete.

These easy steps supply each a shortcut to locking cells in bulk and a option to defend particular cells in Excel.

Easy methods to Shield Formulation in Excel

A inexperienced triangle signifies an error in your cell’s formulation. The error signal will present up in case your formulation is unprotected.

Excel formula error warning

Any unauthorized or unintended modifications to a formulation can alter the integrity of the info reported within the sheet. As such, it is vital to at all times lock your formulation to forestall errors.

This is the way you defend your formulation in Excel:

1. Click on on the cell with the inexperienced triangle and search for the yellow triangle warning signal.

How to Protect Formulas in Excel step 1

2. Click on on the warning signal and choose “Lock Cell.”

How to Protect Formulas in Excel step 2

3. You have to then defend your worksheet by clicking on “Shield Sheet” underneath the “Evaluation” tab.

How to Protect Formulas in Excel step 3

One other option to defend your formulation is by locking every formulation cell individually as you construct your worksheet (as outlined right here) and defending your sheet as soon as all formulation have been locked.

Whether or not you are the particular person fixing the error or the one who made it, following these steps will guarantee it by no means occurs once more. And your cat must discover one thing else to sabotage.

New Call-to-Action

About admin

Check Also

How to Create a Pie Chart in Excel in 60 Seconds or Less

In the beginning of 2021, I used to be tasked with an task: Create a …

Leave a Reply

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

%d bloggers like this: