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.