Policy

Show Formula bar in Normal View

Enabling this setting selects the Advanced (Display) user option to "Show formula bar".

Policy
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / Advanced
Policy ID1abecdca51f2
Internal nameL_ShowFormulabarinNormalView

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\ffmlaf_1_1 (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\ffmlaf_1_1 (disabled) = 0

Policy notes

Enabling this setting selects the Advanced (Display) user option to "Show formula bar".

Related policies

Alert before overwriting cellsAllow formatting and labels to track data pointsAlternate startup file locationAsk to update automatic linksAutomatically Flash FillAutomatically insert a decimal pointCommentsCursor movementCut and copy objects with cellsDefault sheet directionEdit directly in cellEnable AutoComplete for cell valuesEnable automatic percent entryEnable fill handle and cell drag-and-dropExtend data range formats and formulasForce support for Unicode surrogates in Excel 2021 and Excel 2024Function tooltipsIgnore other applicationsMicrosoft Excel menu or Help keyMove selection after Enter