1. Overview

You can use the Insert > Drop‑Down Lists dialog box to enable drop‑down lists for the current field(s) and to manage (create, edit, delete) lists in the current workbook.

When editing a cell with an attached drop‑down list, GS-Calc opens a window displaying a list of values with checkboxes. This allows you to quickly choose predefined field values instead of re‑typing them.

Pressing the cursor keys Up (from the first line of the edited field) or Down (from the last line) switches focus to the list window. To switch back to the edited field, scroll the list to its first item and press Up, or simply click the edited field.

2. Navigating the List

To scroll the list, use the standard cursor keys:

• Up, Down
• PgUp, PgDn
• Home, End

If a list has multiple columns, you can also use Left and Right to jump between columns.

To check or uncheck a list item, press Space or click the checkbox. If the list has multi‑selection disabled, checking a new item automatically unchecks the previously selected one.

To accept selected items, press Enter, double‑click one of the selected items, or click the OK button displayed above the edited field.

3. Displaying and Resizing List Columns

You can display list items in 1 to 99 columns. Dragging the vertical grid lines in the list window resizes all columns. To resize the list window itself, drag its bottom‑right corner or its edges.

4. Creating and Managing Lists

To create a new list, click the New List button. To add items, enter or paste them into the List Items field — one item per line.

The maximum number of list items is the same as the maximum number of worksheet rows: 12 million.

If you select the AutoAppend option, each new unique value entered in the corresponding field(s) will be added to the list automatically.

If you select the AutoComplete option, the edited cell contents will be automatically completed with the matching text from the list after you type the initial characters.

If the Sort items option is not selected, list items appear in the order they were added. Otherwise, items are sorted before displaying.

5. Using Lists Across Worksheets

A single list can be used by any number of cells in any worksheet within the workbook. You can create up to 100 lists per workbook. To move lists between workbooks, copy and paste the data from the List Items field.

6. Notes

If you specify more than one column, splitter lines appear only when list items occupy multiple columns. To resize columns, you may need to temporarily shrink the list window, for example: