Show Formula bar in Full View
| Registry value | ffmlafull_68_1 |
| Group Policy | Show Formula bar in Full View |
| German version | Bearbeitungsleiste im Vollbildmodus anzeigen |
| Intune settings catalog | Show Formula bar in Full View (User) |
| Scope | User · HKCU |
| ADMX | excel16.admx · L_ShowFormulabarinFullView |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\excel\options\binaryoptions | |
| ffmlafull_68_1 | Enabled = 1 · Disabled = 0 |
Not configured = the value does not exist – the application default applies and users may change the setting.
PowerShell
Check the current value (read-only)
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
foreach ($name in @('ffmlafull_68_1')) {
try { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
catch { '{0}: not configured' -f $name }
}Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.
Enable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'ffmlafull_68_1' -PropertyType DWord -Value 1 -Force -ErrorAction Stop | Out-Null # Enabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Disable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'ffmlafull_68_1' -PropertyType DWord -Value 0 -Force -ErrorAction Stop | Out-Null # Disabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Reset to Not configured
# --- Settings --- $root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>' $key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions" Remove-ItemProperty -Path $key -Name 'ffmlafull_68_1' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Show Formula bar in Full View (User)
Settings catalog → Add settings → search for the name above.
Intune Settings Catalog Viewer ↗
Alternative: custom profile (OMA-URI)
| OMA-URI | ./User/Vendor/MSFT/Policy/Config/excel16v2~Policy~L_MicrosoftOfficeExcel~L_ExcelOptions~L_Advanced/L_ShowFormulabarinFullView |
| Data type | String |
| Value | <enabled/> · <disabled/> |
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Show Formula bar in Full View. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft explanation
Checked: Displays the Formula bar when the Full Screen command in the View menu is set. | Unchecked: Does not dispaly the Formula bar when the Full Screen command in the View menu is set.
Same category: Microsoft Excel 2016 › Excel Options › Advanced
- Number of folders in the Recent Folders listmax display
- Default sheet directiondefaultsheetr2l
- Cursor movementcursorvisual
- Show control characterscontrolcharacters
- Microsoft Excel menu or Help keymenukey
- Transition navigation keysfisi_33_1
- Ignore other applicationsfddeenabled_6_1
- Zoom on roll with IntelliMousefrollzoom_98_1
- Show namesfshowchartnames_96_1
- Show valuesfshowcharttipvalues_97_1
- Edit directly in cellfnoincell_66_1
- Enable fill handle and cell drag-and-dropfdisabledman_36_1
All policies in this category · All 173 policies of excel16.admx