First go to the view tab and from the show group and tick mark formula bar. Hiding and protecting formulas is currently not supported in Excel for the web. Open the desired Excel sheet and click on Formulas tab available on Menu Bar.
Please refer the below screenshot.
You can also hide the Formula Bar via the Excel Options dialog. If you want to unhide column A select the column by typing A1 into the Name Box which is located to the left of the formula bar. Show or hide the Formula Bar with Kutools for Excel 1. Display or Hide the Formula Bar in Excel Open your spreadsheet and click on the File menu.