The formula bar is an editable line where you can enter, edit, and view data and formulas.
You can change the height of the Formula bar to make it easier to work with a large amount of information in a cell. To do this, proceed as follows:
1.Move the cursor to the bottom border of the bar. The cursor will look like .
2.Hold down the left mouse button and drag the bar border down or up.
3.Release the left mouse button.
The last set height is saved for both the current and subsequent sessions in the application, but may be reset when you install updates. At the same time, changing the bar height does not affect already opened documents.
Pressing Alt+Enter (Windows, Linux) or Option+ Enter (macOS) while typing characters into a cell does not enlarge the Formula bar.
The size of the Formula bar is limited by the workspace: at least one row must be displayed in the workspace.
To quickly return the bar size to the default size, you can collapse the bar. To do this, proceed with one of the following:
•Double-left-click the bottom border of the bar.
•Click Collapse formula bar.
•Press Ctrl+Shift+U (Windows, Linux) or Cmd+ Shift+U (macOS).
To quickly expand the bar, do one of the following:
•Click Expand formula bar.
•Press Ctrl+Shift+U (Windows, Linux) or Cmd+ Shift+U (macOS).
The line will be expanded to the size previously set manually or to the default size (72 pixels).
|