Explainry Tutorials to Expert in IT

Formula bar in Google Sheets

Previous Lesson: Zoom in or Out

The formula bar displays values of an active cell, these values either be a text value, a number value or a formula (instead of formula answer).

In the above example, the formula bar is displaying the formula “=SUM(A1:A4)” located in the active cell A5.

Editing the formula bar

To edit data in the formula bar, click on the formula bar and edit the formula.

Hide/ unhide formula bar in Google Sheets

1- To hide the formula bar, visit the View tab, select Formula bar.

2- Result. The formula bar is not displaying.

Similarly, to unhide the formula bar repeat the same steps.

Expanding the formula bar

If you have a lengthy formula, which is not readable in the formula bar. You can expand the formula bar by clicking and dragging it down.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved