How to Lock and Protect Cells in Excel from editing

Microsoft Excel allows users to edit a cell in the cell itself. However, if you need to use a lot of big and complicated formulas, you might need to use the Formula bar. On the other hand, if you need to enter texts larger than the cell size, you need to use the same bar. That is why you can stop yourself or users from editing directly in the cell in Excel. After enabling this setting, you will be able to edit the cell in the Formula bar directly.

How to Lock and Protect Cells in Excel from editing

To stop users from editing directly in cell in Excel, follow these steps:

  1. Open Microsoft Excel.
  2. Click on the Options.
  3. Switch to the Advanced tab.
  4. Remove the tick from the Allow editing directly in cells checkbox.
  5. Click the OK button.

Let’s check out these steps in detail.

For getting started, open Microsoft Excel and click on the Options menu. Then, switch to the Advanced tab on the left side.

Here you can find a setting called Allow editing directly in cells. By default, it should be enabled. You need to remove the tick from the corresponding checkbox.

How to stop users from editing directly in cell in Excel

Click the OK button to save the change.

Stop users from editing directly in a cell in Excel using Group Policy

To stop users from editing directly in a cell in Excel using Group Policy, follow these steps:

  1. Press Win+R > type gpedit.msc and hit the Enter button.
  2. Go to Advanced in User Configuration.
  3. Double-click on the Edit directly in cell setting.
  4. Choose the Disabled option.
  5. Click the OK button.

To know more about these steps, continue reading.

First, you must open the Local Group Policy Editor on your computer. For that, press Win+R to display the Run prompt, type gpedit.msc, and hit the Enter button.

Once it is opened, navigate to the following path:

User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Advanced

Double-click on the Edit directly in cell setting and choose the Disabled option.

How to Lock and Protect Cells in Excel

At last, click the OK button to save the change and restart the Microsoft Excel to apply it.

Disable editing directly in a cell in Excel using Registry

To disable editing directly in a cell in Excel using Registry, follow these steps:

  1. Press Win+R to open Run dialog.
  2. Type regedit and press the OK button.
  3. Click the Yes button.
  4. Navigate to Microsoftoffice16.0excelin HKCU.
  5. Right-click on excel > New > Key and name it as options.
  6. Right-click on options > New > Key and name it as binaryoptions.
  7. Right-click on binaryoptions > New > DWORD (32-bit) Value.
  8. Set the name as fnoincell_66_1.
  9. Double-click on it to set the Value data as 1.
  10. Click the OK button.
  11. Restart your computer.

To find out more about these aforementioned steps, continue reading.

Once it is opened, navigate to this path:

HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0excel

Right-click on excel > New >Key and name it as options. Then, right-click on the options > New > Key and set the name as binaryoptions.

How to stop users from editing directly in cell in Excel

Next, right-click on binaryoptions > New > DWORD (32-bit) Value and call it fnoincell_66_1.

How to stop users from editing directly in cell in Excel

Then, double-click on it and set the Value data as 1.

How to stop users from editing directly in cell in Excel

Finally, click the OK button, close all the windows, and restart your computer.

How do you prevent people from editing a cell in Excel?

To prevent people from editing a cell in Excel, you need to use the in-built option called Allow Edit Range. It helps you select a range to allow or block users from editing them. You can find this option in the Review tab under the Protect section.

How do you lock cells so only one person can edit?

To lock cells so only one person can edit, you need to use a password. For that, open the sheet and go to the Review tab. Click on the Protect Sheet option and enter a password. Then, you can share the sheet with anybody without allowing them to edit.

That’s all! Hope this guide helped.

Read: Prevent users from setting personal site as default location in Office.

How to Lock and Protect Cells in Excel

Source link

Alice AUSTIN

Alice AUSTIN is studying Cisco Systems Engineering. He has passion with both hardware and software and writes articles and reviews for many IT websites.

Leave a Reply