Comments
Explanation
Determines how comments are displayed on the worksheet.
Registry
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions- Value name
- not defined in the ADMX
| State | Value written | ||||||
|---|---|---|---|---|---|---|---|
| Enabled | not defined in the ADMX (see the options below) | ||||||
| Disabled |
|
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Enable
# Enable: excel16/L_Comments
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Comments
# Possible options:
# None = 0 (+ fnoteoffv5_35_1=1)
# Comment indicator only = 1 (+ fnoteoffv5_35_1=0)
# Comment & indicator = 2 (+ fnoteoffv5_35_1=0)
Set-ItemProperty -Path $k -Name 'vmdnotedisp_38_2' -Value 1 -Type DWord
Set-ItemProperty -Path $k -Name 'fnoteoffv5_35_1' -Value 0 -Type DWordDisable
# Disable: excel16/L_Comments
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
Remove-ItemProperty -Path $k -Name 'fnoteoffv5_35_1' -ErrorAction SilentlyContinueRevert to "Not configured"
# Revert to "Not configured": excel16/L_Comments
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
Remove-ItemProperty -Path $k -Name 'fnoteoffv5_35_1' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'vmdnotedisp_38_2' -ErrorAction SilentlyContinueOptions (1)
| Label | Control | Registry value | REG type | Constraints / details | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CommentsL_comments85 | Drop-down listenum | vmdnotedisp_38_2 | REG_DWORD | Default choice (UI): #1
|
Application
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.