For example if you type the formula above 32 into a cell and press Enter the result 5 appears in the cell. You can drag the formula bar to make it larger or smaller using this arrow. Click Kutools Show Hide View Options see screenshot.
In the View Options dialog box check or uncheck the Formula Bar option under the Application Settings section.
Uncheck the box labeled Show Formula Bar and click OK. After you type the formula and press Enter on your keyboard the result of the formula appears in the cell. Display or Hide the Formula Bar in Excel Open your spreadsheet and click on the File menu. Click File Options to go to the Excel Options dialog box then click General from the left pane.