Application window > Edit toolbar

In the ribbon interface as well as in the classic menus you will find the Edit toolbar below the ribbon (or below the standard toolbar and formatting toolbar in the classic menu interface).

The Edit toolbar contains the following options:

Cell address

The address of the currently active cell is displayed on the far left.

Icons and input field for editing cell contents

Three icons and an input field can be found to the right of the cell address.

Click in the input field to edit the content of the current cell. Alternatively, you can edit the cell content directly by simply clicking in the cell and starting to type. The latter option is usually faster.

For more information on entering and editing data in cells, see Entering data in cells.

The buttons next to the cell address have the following functions:

Icon	Function
	This button corresponds to choosing the ribbon command Formula \| Function (menu command Insert > Function)
	This button accepts the entry in the input field (corresponds to pressing the Enter key↵)
	This button rejects the entry in the input field (corresponds to pressing the Esc key)

For more information on entering formulas, see Formulas and functions.

Expanding the input field

The input field of the edit bar is usually displayed with one line. For longer formulas, however, it is helpful if the input field expands so that you can see the formula completely.

With the button to the right of the input field you can set whether the input field should expand. Click this button and choose from the following options in the menu that appears:

▪Automatic

The input field is displayed with one line by default. If the space is no longer sufficient to display the formula in one line, the input field is automatically extended to four lines.

▪One line

The input field is always displayed in one line, even if the formula exceeds one line.

▪Four lines

The input field is always displayed in four lines, even if the formula fits in one line.

Tip: These options can also be found in the dialog box of the command File | Options , on the Edit tab.

Note: If the button described above is not available, click the icon on the far right of the edit bar. Select Add/remove Buttons and enable Input field height.