Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • Gmail
    • Productivity
      • Time Management
      • Task Automation
    Inside The Web
    Home»Excel»Formula Bar Not Showing in Excel- How to fix it

    Formula Bar Not Showing in Excel- How to fix it

    AsmiBy AsmiMarch 5, 2023 Excel 4 Mins Read

    The formula bar is a useful tool for performing calculations that involve complex functions and formulas like conditional statements, lookup functions, dynamic array formulas and so on.

    It’s always a better idea to type your formulas from the formula bar. This will give you a better view of the formula, causing fewer errors.

    With all the functionality it brings on the plate, if the formula bar goes missing, it could have an impact on your productivity. However, most of the time there isn’t a complex reason behind the formula bar missing in your Excel program.

    Excel offers customizability in how you wish to view the program, so it could be possible that you accidentally disabled the formula bar from the program view.

    Unhide Formula Bar from the View Tab

    You can hide and unhide various elements including gridlines, headings, and the formula bar from the View tab. If you’ve accidentally hidden it, you can enable it from this section of the menu bar.

    1. Open your spreadsheet.
    2. From the menubar, select View.
    3. Check the box next to Formula bar.
      Show Formula bar Excel

    Show Formula Bar from Excel Options

    You can also bring the formula bar back on display from the Excel options.

    1. Head to File from the menubar.
    2. Select Options from the sidebar.
      Excel Options
    3. In the Excel Options window, select Advanced.
    4. Scroll down to the Display section and select the box next to Show formula bar.
      Show Formula bar from Excel options

    Reset Preference

    If you’re still having problems enabling the formula bar, you can choose to reset all customizations you’ve made in your Excel program. Unfortunately, this will disable other settings you’ve configured in Excel, including the Developer tab. So, only use this method as the last resort when you cannot find the Formula bar at all.

    1. Head to File then open Options from the sidebar.
      Excel Options
    2. From the window, open Quick Access Toolbar.
    3. Next to Customizations, select Reset.
    4. Select Reset customization.
      Reset Excel preference

    Reset Excel to Default Settings

    If even resetting the preference doesn’t work, it’s because there is something wrong with your application. In this case, you will have to perform a factory reset that will cause you to lose your system preference but will not affect your saved documents, macros, and add-ins. Make sure you close all active workbooks before you proceed.

    1. Open the Run command (Ctrl + R).
    2. Type regedit and hit Enter.
      Open Registry
    3. Expand the menu for HKEY_CURRENT_USER.
      Registry Editor
    4. Expand Software > Microsoft > Office.
    5. Depending on your Excel version, expand 12.0(Excel 2007), 14.0(Excel 2010), 15.0(Excel 2013), or 16.0(Excel 2016 or later)
    6. Right-click on Excel and select Delete.
      Restore Excel to Factory Settings
    7. Restart Excel.

    Frequently Asked Questions (FAQs)

    How to Expand Formula Bar in Excel?

    If you’re dealing with a very long formula, the normal size of your formula bar may not be the right choice for you. Fortunately, Excel allows its users to expand their formula bars to accommodate longer formulas.

    Simply, place your cursor on the extreme right of your formula bar and select the drop-down icon. If you like using Excel shortcuts, you can also hit the Ctrl + Shift + U keys to expand your formula bar.

    Expand Formula bar Excel

    If you want to shrink your formula bar, you can click on the same icon and re-use the Ctrl + Shift + U shortcut.

    Shrink Formula bar in Excel

    Can I re-position the Formula bar in Excel?

    Many users opt to hide the formula bar when they’re analyzing data in a spreadsheet. This is to prevent any distraction from the sheet view.

    While you can hide, expand, or shrink the formula bar, Excel currently doesn’t offer the feature to change the position of the formula bar. If you wish to hide the formula bar, you can head to the View tab and deselect the box next to the Formula bar.

    Excel Basics
    Asmi

      Asmi is a content writer specializing in MS Office. She loves writing Excel-related content to assist other users to learn their way around the program. She started using Excel when she first entered the industry as a marketing intern. Soon, she realized that learning the often-overlooked spreadsheet program was no piece of cake. In her articles, she attempts to brief out complex topics to help beginner to intermediate-level Excel users. Asmi uses Excel for everything, including creating a grocery list to managing her personal finance. She’s a bit dramatic when it comes to the Flash Fill feature; so much so that could write a eulogy out of it. When she’s not working, you’ll find her learning a new recipe, or cleaning up her mess (out of the failed recipe).

      Add A Comment
      Table of Contents
      • Unhide Formula Bar from the View Tab
      • Show Formula Bar from Excel Options
      • Reset Preference
      • Reset Excel to Default Settings
      • Frequently Asked Questions (FAQs)
        • How to Expand Formula Bar in Excel?
        • Can I re-position the Formula bar in Excel?
      Recent Posts
      • How to Lock a Cell in Excel Formula
      • How to Make Gridlines Darker in Excel
      • How to Apply Cell Style in Excel
      • How to Apply Top and Bottom Border in Excel
      • How to Retrieve Last Value in Column Excel
      • Home
      • Privacy Policy
      © 2023 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.