End Sub To turn the formula bar on, enter this code: Sub OnFormulaBar() Application.DisplayFormulaBar = True End Sub Is there a shortcut to hide the formula bar in Excel? Yes, pressing ALT W , V , F ...