How to Enlarge or Disable the Excel Formula Bar


excelAs you know, when you select a cell in your worksheet in Excel, you can see the contents of that cell in your Formula Bar. If, however, the content is longer that what can be displayed in a single line on your Formula Bar, the depth of the Bar will grow so that your entire formula can be displayed. Once you move to another cell, your Formula Bar will again decrease to a single line.

So what’s the problem here? Well, when your Formula Bar adjusts automatically, it can hide other elements on your screen. For instance, if your Formula Bar is two or three lines in depth, it covers your column headers and other cells in your worksheet which can prove to be annoying.

There are a couple of methods to get around this impediment. Follow the steps below to learn how:

Firstly, Excel will allow you to modify the number of lines you can use in your Formula Bar, so that it will always allow you to use so much space and it will not automatically adjust. To expand your Formula Bar, click the tool at the very right edge of your Formula Bar. When you hover your cursor over the tool, the ToolTip will say Expand Formula Bar.

Secondly, you can simply turn off the Formula Bar entirely. If you choose this method, follow the steps below:


  1. On the File tab of your Ribbon, click Options to display the dialog box.
  2. At the left-hand side of the dialog box, select Advanced.
  3. Scroll through your options until you see the Display Section.
  4. Deselect the Show Formula Bar check box.

excel display section

  1. Click on OK.

 

Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

2 Comments

  1. I am currently using Office 2007 with which I am quite comfortable. I primarily use Excel and Word in that order. However I am aware that both 2010 and 2013 allow customization of the ribbon. While that would be convenient, it alone would not convince me to upgrade. Would you advise an upgrade and, if so, to which?

  2. I think it is a matter of personal taste. I personally like to have the ability to customize the Ribbon so that I can save time and keystrokes, but if that is not a big deal to you, then I wouldn’t bother.

    If I were going to upgrade though, it would be to office 2016 because even though it has not changed a great deal, there are still some changes that are significantly better in my opinion than what is offered in Office 2013.