Show or Hide Formula Bar in Excel – Quick Tip

This quick tip teaches you how to show or hide the formula bar in Excel.

Steps to Show or Hide Formula Bar in Excel

Follow the steps below to display or hide the formula bar in Excel.

Show or Hide Formula Bar in Excel
Display or Hide Formula Bar in Excel.
  1. Click View from the menu bar.
  2. Under the Show group, check or un-check Formula Bar.

As you may see, the formula bar also includes the Name Box. It is generally to the left of the formula bar. In the above image, A1 is in the name box.

Success!

Now, you can toggle the formula bar, on or off.


Additional Information

Questions or Comments

Feel free to email us at training@techronology.com with any questions or comments.

External Links

Display or hide formulas


Tutorials

Techronology Home