Edit directly in cell

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options\binaryoptions

Value name: fnoincell_66_1

Enabled: fnoincell_66_1 = 0

Disabled: fnoincell_66_1 = 1

Description

This policy setting sets the "Edit directly in cell" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will allow editing directly in the cell This is the default behavior. If you disable this policy setting, Excel will not allow editing to be done directly in the cell.