Controlling Display of the Formula Bar

by Allen Wyatt
(last updated April 3, 2014)

1

The formula bar is the area at the top of the Sheets screen, just below the toolbar and just above the spreadsheet itself. The formula bar displays the contents of the currently selected cell. If you need more room to view a spreadsheet, or you don't need the information provided by the formula bar, you can turn it off.

To control display of the formula bar, simply choose View | Formula Bar. This option is a toggle; repeatedly selecting it turns the formula bar on and off. You can tell if the formula bar is displayed by (of course) seeing the formula bar on the screen, but you can also see a check mark beside the Formula Bar option on the View menu.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Turning Off Capital Corrections

Tired of having Excel second-guess you when you type a word that starts with two capital letters? You can turn off this ...

Discover More

Copying a Chart and Related Shapes to a Word Document

Excel and Word are intended to work together, but sometimes it can seem that getting them to do so isn't that intuitive. One ...

Discover More

Viewing Your Entire Document Width

The Zoom tool is very useful to help you see all of your document information. Here's how to make sure you can see all the ...

Discover More
More DriveTips

Changing Vertical Cell Alignment

If you have a large row height, you may want to adjust how the information in a cell is aligned vertically. Sheets allows you ...

Discover More

Inserting Rows

As you are developing a spreadsheet, you'll often have the need to insert additional rows into your data. Sheets makes this ...

Discover More

Creating a Conditional Format

Conditional formatting is a powerful tool you can use to dynamically adjust the formatting in your worksheet. This tip gives ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is six less than 6?

2014-04-03 06:27:06

JD Murphy

The formula bar seems to have only two options : 1 or 2 lines. Can this be increased?
JD