The formula bar is a useful tool for editing the contents of cells, particularly for creating and editing formulas.
When working in a Sheet View, the formula bar sits between your column headers and the toolbar and will display the contents of the currently selected cell, whether it contains a formula or manually inputted data.
What is the Formula Bar?
The formula bar allows you to easily add and edit existing formulas. It is especially useful for seeing and editing complex formulas like this:
From the formula bar, you can click on any part of the formula to make changes. You can even edit cell entries that are not formulas like long text passages, dates, names, and more.
Hiding and Unhiding the Formula Bar
The formula bar can be toggled on and off. Open the document menu and navigate to View > Formula bar.
How to Access the Document Menu
To access the document menu,
- Open the document dropdown by clicking the arrow to the right of the document name
- Select "Menu..." from the dropdown
Or, open the Sheet Display Settings dialog and Select "Show Formula bar". You can also use the keyboard shortcut Ctrl. + .
If you open a Sheet view and don't see the formula bar, it is likely hidden.
Using the Formula Bar
To access the formula bar, click on a cell that you wish to add or edit a formula or data in and then click on the formula bar at the top. From here you can navigate within or edit the formula as desired. When you've finished inputting or editing your formula, hit the Enter key on your keyboard and the corresponding cell will automatically update.
Read on to learn more about working with Formulas and Advanced Data Types, including Formula Output Syntax for Data Types and The Column Formula Data Type.