1. Overview

The List of Functions dialog box helps you enter built‑in functions more easily when editing formulas.

This dialog box is displayed automatically when editing a cell or when activating the Formula edit field on the toolbar. The Insert > Formula command simply starts editing the current cell.

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

2. Function Name Assistance

If you enter an incorrect function name (including the opening parenthesis), the dialog box will display possible correct functions.

To insert a function name, double‑click it or press Enter. The name is inserted at the cursor position within the edited cell. If any text is selected, the selection is replaced.

3. Display Options

The List of Functions dialog box is displayed automatically if the edited cell begins with “=” indicating a formula. You can also choose other display options: