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.

There are 2 comments

Comments are closed.