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 control elements:
Cell address
The address of the currently active cell is displayed at the very left.
Symbols and input field for editing cell contents
To the right of the cell address are three icons and an input field.
Click into the input field to edit the content of the current cell. Or, to edit the cell directly, simply click in the cell and begin typing. The latter is usually faster.
For more information on entering and editing cells, see Entering data in cells.
The Edit toolbar icons have the following functions:
Icon |
Function |
|
Corresponds to choosing the ribbon command Formula | Function (menu command Insert > Function) |
|
Accepts the user input in the input field (corresponds to pressing the Enter key↵) |
|
Cancels the user input in the input field (corresponds to pressing the Esc key) |
For more information on entering formulas, see Formulas and functions.