Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Controlling Display of the Formula Bar

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Controlling Display of the Formula Bar.

The Formula Bar is the area at the top of the Excel window, just below the ribbon area. The Formula Bar has two parts: at the left is the Name Box, and to the right is the contents of the currently selected cell.

If you need more room to view a worksheet or you don't need the information provided by the Formula Bar, you can turn it off. To control display of the Formula Bar, follow these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the View tab is selected. (See Figure 1.)
  3. Figure 1. The View tab of the Options dialog box.

  4. Click on the Formula Bar check box. If it is selected, then the Formula Bar is displayed; not selected means it isn't displayed.
  5. Click on OK.

You can also use the Formula Bar option from the View menu. This option functions like a toggle—click on it once, and the Formula Bar disappears; click again, and it reappears.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2729) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Controlling Display of the Formula Bar.

Related Tips:

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

Jahn Ghalt    21 Sep 2016, 13:22
Is there a way to restore Excel 2003 function to the formula bar - in Excel 2013??

Specifically, in v2003 the formula bar automatically resizes to display the entire formula in the related cell (including alt-enter line breaks).

More generally is there an effective place to plead for sanity for future versions and/or "patches" of recent excel versions??
Abiodun    23 Jun 2016, 15:09
i am interested in microsoft excdel. i wish to learn it to high length
Chris    31 Aug 2015, 09:20
Go to VIEW then scroll to FORMULA BAR.
Duane Kriesel    18 Apr 2015, 12:28
Using both 2003 and 2007 The Formula bar disappeared in the 2007 version. You reference the TOOLS tab but there is no tool tab in my 2007 version.

Help
Pat O'Leary    21 Nov 2014, 09:46
I would like the fx bar to show the formula and not the result but I cannot find a resolution to fix this. I've tried to hi-lite the fx bar and press F9 as some have suggested but this doesn't change anything.
Dan    22 Nov 2013, 10:57
I'm using Excel for Mac 2008 and would like the formula bar to be permanently displayed.

The pathway described above - indeed 'options' in general - does not seem to exist.

Help?
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.