Show Formula bar in Normal View

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

Registry

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

Value name: ffmlaf_1_1

Enabled: ffmlaf_1_1 = 1

Disabled: ffmlaf_1_1 = 0

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