5 Ways Unhide Formula Bar

Introduction to Excel Formula Bar

The Formula Bar in Excel is a useful tool that allows users to view and edit formulas and data in a cell. It is located below the ribbon and displays the contents of the active cell. However, sometimes the Formula Bar may be hidden, and users may need to unhide it to view or edit formulas. In this article, we will discuss 5 ways to unhide the Formula Bar in Excel.

Method 1: Using the Ribbon

To unhide the Formula Bar using the ribbon, follow these steps: * Go to the View tab in the ribbon. * Check if the Formula Bar checkbox is selected. If it is not selected, click on it to select it. * The Formula Bar will be displayed below the ribbon.

Method 2: Using the Keyboard Shortcut

Another way to unhide the Formula Bar is by using the keyboard shortcut: * Press Ctrl + ` (grave accent) to toggle the Formula Bar on or off.

Method 3: Using the Excel Options

To unhide the Formula Bar using Excel options, follow these steps: * Go to the File tab in the ribbon. * Click on Options. * In the Excel Options dialog box, click on Advanced. * Scroll down to the Display section. * Check if the Formula Bar checkbox is selected. If it is not selected, click on it to select it. * Click OK to close the dialog box.

Method 4: Using the Quick Access Toolbar

To unhide the Formula Bar using the Quick Access Toolbar, follow these steps: * Click on the Down arrow in the Quick Access Toolbar. * Click on More Commands. * In the Excel Options dialog box, click on Customize Ribbon. * Click on All Commands in the Choose commands from dropdown list. * Scroll down and select Formula Bar. * Click Add to add the Formula Bar to the Quick Access Toolbar. * Click OK to close the dialog box.

Method 5: Using VBA Code

To unhide the Formula Bar using VBA code, follow these steps: * Press Alt + F11 to open the Visual Basic Editor. * In the Visual Basic Editor, click on Insert > Module. * Paste the following code: Application.DisplayFormulaBar = True. * Press F5 to run the code. * The Formula Bar will be displayed below the ribbon.

📝 Note: The above methods will work in most versions of Excel, including Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

In summary, there are several ways to unhide the Formula Bar in Excel, including using the ribbon, keyboard shortcut, Excel options, Quick Access Toolbar, and VBA code. By following these methods, users can easily view and edit formulas in the Formula Bar.