Hide or unhide formula bar using the Excel Options Uncheck or check the Formula Bar option in the Show section.When you have an active Excel workbook, follow the steps below. This option can be found directly on the Ribbon. Hide or unhide formula bar using the Excel Ribbon You have 3 options to do this: using the Excel Ribbon, Excel Options, or VBA. In this guide, we’re going to show you how to make Excel show formula bar or hide it. Alternatively, you may want to show it instead, if the bar is missing. However, you may want to hide the formula bar either to limit user interaction with it, or to give your Excel workbook a compact look and feel. This sets your Excel spreadsheet back to the Automatic setting so that it recalculates formulas every time a change is made to your spreadsheet.By default, the formula bar is visible in Excel to allow you to see and enter formulas in the active cell. Under the Calculation heading, select the option Automatic and click OK.From the top of the Excel window, select the drop-down menu Tools and from within this, select Options.This will display the 'Excel Options' dialog box Select the option Excel Op tions from the main Excel menu (displayed by clicking on the Excel Logo at the left of the Excel ribbon).Under the Calculation options heading, select the option Automatic and click OK.Select the option Formulas from the list on the left of the dialog box.

Select the File tab on the Excel ribbon, and from this, click on Options to display the 'Excel Options' dialog box.Use the mouse to select the cell(s) containing the formula (this must be done one column at a time).This can be done using Excel's Text To Columns tool as follows: To correct this, you need to convert the cell's data type to the 'General' data type. This formatting will cause Excel to interpret anything that is subsequently entered into the cell (including formulas) as text. You have insert a new column next to a column that is formatted as text, and the new column has 'inherited' the formatting of the adjacent column.A text format has previously been applied to the cell.

This problem often arises because the cells containing the formula are formatted as 'text' instead of the 'General' type. You type in a function and when you press Enter, the cell displays the actual function text, instead of calculating the function's value. Case Number 1: The Cell Displays the Function Instead of its Calculated Value

Excel is showing formula not result