Microsoft Excel permits customers to edit a cell in the cell itself. Nonetheless, for those who want to use a whole lot of huge and sophisticated formulation, you would possibly want to use the Formulation bar. However, for those who want to enter texts bigger than the cell dimension, you want to use the identical bar. That’s the reason you’ll be able to cease your self or customers from editing instantly in the cell in Excel. After enabling this setting, it is possible for you to to edit the cell in the Formulation bar instantly.
How to Lock and Protect Cells in Excel from editing
To cease customers from editing instantly in cell in Excel, observe these steps:
- Open Microsoft Excel.
- Click on on the Choices.
- Swap to the Superior tab.
- Take away the tick from the Permit editing instantly in cells checkbox.
- Click on the OK button.
Let’s take a look at these steps in element.
For getting began, open Microsoft Excel and click on on the Choices menu. Then, swap to the Superior tab on the left aspect.
Right here you will discover a setting referred to as Permit editing instantly in cells. By default, it needs to be enabled. You want to take away the tick from the corresponding checkbox.
Click on the OK button to save the change.
Cease customers from editing instantly in a cell in Excel utilizing Group Coverage
To cease customers from editing instantly in a cell in Excel utilizing Group Coverage, observe these steps:
- Press Win+R > kind gpedit.msc and hit the Enter button.
- Go to Superior in Consumer Configuration.
- Double-click on the Edit instantly in cell setting.
- Select the Disabled possibility.
- Click on the OK button.
To know extra about these steps, proceed studying.
First, you will need to open the Native Group Coverage Editor in your pc. For that, press Win+R to show the Run immediate, kind gpedit.msc, and hit the Enter button.
As soon as it’s opened, navigate to the next path:
Consumer Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Choices > Superior
Double-click on the Edit instantly in cell setting and select the Disabled possibility.
Eventually, click on the OK button to save the change and restart the Microsoft Excel to apply it.
Disable editing instantly in a cell in Excel utilizing Registry
To disable editing instantly in a cell in Excel utilizing Registry, observe these steps:
- Press Win+R to open Run dialog.
- Kind regedit and press the OK button.
- Click on the Sure button.
- Navigate to Microsoftoffice16.0excelin HKCU.
- Proper-click on excel > New > Key and identify it as choices.
- Proper-click on choices > New > Key and identify it as binaryoptions.
- Proper-click on binaryoptions > New > DWORD (32-bit) Worth.
- Set the identify as fnoincell_66_1.
- Double-click on it to set the Worth information as 1.
- Click on the OK button.
- Restart your pc.
To search out out extra about these aforementioned steps, proceed studying.
To get began, press Win+R to pen the Run dialog, kind regedit, and press the OK button. Then, click on on the Sure possibility in the UAC immediate to open the Registry Editor.
As soon as it’s opened, navigate to this path:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0excel
Proper-click on excel > New >Key and identify it as choices. Then, right-click on the choices > New > Key and set the identify as binaryoptions.
Subsequent, right-click on binaryoptions > New > DWORD (32-bit) Worth and name it fnoincell_66_1.
Then, double-click on it and set the Worth information as 1.
Lastly, click on the OK button, shut all of the home windows, and restart your pc.
How do you stop folks from editing a cell in Excel?
To stop folks from editing a cell in Excel, you want to use the in-built possibility referred to as Permit Edit Vary. It helps you choose a spread to enable or block customers from editing them. Yow will discover this selection in the Evaluation tab underneath the Protect part.
How do you lock cells so just one particular person can edit?
To lock cells so just one particular person can edit, you want to use a password. For that, open the sheet and go to the Evaluation tab. Click on on the Protect Sheet possibility and enter a password. Then, you’ll be able to share the sheet with anyone with out permitting them to edit.
That’s all! Hope this information helped.
Learn: Forestall customers from setting private website as default location in Workplace.
