Entering data: Formula Composer

Use the List Of Functions dialog box to make it easier to enter the built-in functions.

The List Of Functions dialog box is displayed by default when editing a cell and after activating the Formula edit field on the toolbar. The Insert > Formula command simply starts editing of the current cell.

The List Of Functions dialog box can be resized. To resize the field containing descriptions and the list of functions, drag the splitter line separating both parts of that dialog box.

*

If you enter an incorrect name of a function including the starting '(', the dialog box will list possible correct functions.

*

To insert a given name, double-click it or press Enter. The name is inserted at the cursor position within the edited cell. If there any selection, the selection is replaced.

The above List Of Functions dialog box is displayed by default if a given cell contains the initial '=' indicating a formula. You can also select other options:

*