Comments: registry value fnoteoffv5_35_1 and 1 moreUserHKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions

Policy ID: L_Comments
Scope: User Configuration
Supported on: At least Windows Server 2008 R2 or Windows 7
Source: Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
Category: Microsoft Excel 2016 › Excel Options › Advanced

Registry

fnoteoffv5_35_1

Delete valueUser

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

Disabled value: (delete value)

Apply with .reg · CMD · PowerShell

Disabled

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions]
"fnoteoffv5_35_1"=-

CMD · Disabled

reg delete "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /f

PowerShell · Disabled

Remove-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1'

vmdnotedisp_38_2

REG_DWORDUser

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

Enabled value: Depends on the option value
Element: Comments

Options
Item	Stored value
None	0 software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnoteoffv5_35_1 = 1
Comment indicator only	1 software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnoteoffv5_35_1 = 0
Comment & indicator	2 software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnoteoffv5_35_1 = 0

Apply with .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions]

; Options (use only one)
; None
"vmdnotedisp_38_2"=dword:00000000
"fnoteoffv5_35_1"=dword:00000001
; Comment indicator only
"vmdnotedisp_38_2"=dword:00000001
"fnoteoffv5_35_1"=dword:00000000
; Comment & indicator
"vmdnotedisp_38_2"=dword:00000002
"fnoteoffv5_35_1"=dword:00000000

CMD

:: Options (use only one)

:: None
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "vmdnotedisp_38_2" /t REG_DWORD /d 0 /f
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /t REG_DWORD /d 1 /f
:: Comment indicator only
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "vmdnotedisp_38_2" /t REG_DWORD /d 1 /f
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /t REG_DWORD /d 0 /f
:: Comment & indicator
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "vmdnotedisp_38_2" /t REG_DWORD /d 2 /f
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /t REG_DWORD /d 0 /f

PowerShell

# Common: create the key
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Force | Out-Null

# Options (use only one)
# None
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'vmdnotedisp_38_2' -PropertyType DWord -Value 0 -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1' -PropertyType DWord -Value 1 -Force | Out-Null
# Comment indicator only
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'vmdnotedisp_38_2' -PropertyType DWord -Value 1 -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1' -PropertyType DWord -Value 0 -Force | Out-Null
# Comment & indicator
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'vmdnotedisp_38_2' -PropertyType DWord -Value 2 -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1' -PropertyType DWord -Value 0 -Force | Out-Null