Cell Dropdowns

You can add a dropdown menu to a cell to help users select values quickly and consistently. This is useful when building structured forms, guided inputs, or interactive dashboards inside a worksheet.

Different dropdown types are available depending on the kind of input you want to capture—lists, dates, colors, numeric values, workflows, and more.

Cell dropdown types

The following dropdown types are available to populate cells:

Cell DropDown	Description
Calculator	Opens a calculator and inserts the computed result into the cell.
Color Picker	Lets the user choose a color and stores the selected color’s hex code in the cell.
DateTime Picker	Allows selecting both a date and a time.
List	Displays a predefined list of values for the user to choose from.
Month Picker	Lets the user select a month (January–December).
Slider	Provides a slider control for selecting a numeric value within a defined range.
Time Picker	Allows selecting a specific time of day.
Workflow List	Shows a list of workflow‑driven options that update based on previous selections.
Multicolumn List	Displays a scrollable list with multiple columns and an editable input field. The selected item is returned and remains highlighted when reopened.

Create a dropdown list

1. On the Home tab, open the Styles section.
2. Select Cell Editors, then choose Cell Dropdowns, and pick the dropdown type you want.
3. In the Format Cells dialog, review the Cell Button, which opens by default and contains the shared parameters for all dropdown types.
4. Configure the settings in the Cell Button section to your needs.
5. Select Ok.

Edit or remove a dropdown list

Edit a cell dropdown

1. Right-click the cell.
2. Select Edit Cell Dropdowns.
3. Make the necessary changes using the same steps used when creating the dropdown.

Remove a cell dropdown

1. Select the cell.
2. On the Home tab, open the Styles section.
3. Section, select Cell Editors, then choose Cell Dropdowns, and finally Clear CellType.

Cell button settings

Setting	Description
Command dropdown	(button list on the left) Displays the dropdown type selected in the Command list, reflecting your choice from Cell Dropdowns. Select Add to insert additional dropdowns and assign a command to each one.
UseButtonStyle	Makes the cell appear as a button.
Position	Defines where the dropdown icon appears within the cell.
Width	Sets the width of the dropdown.
Caption	Optional text label displayed beside the icon.
BackColor	Sets the background color of the dropdown.
Hover BackColor	Sets the background color when the pointer hovers over the dropdown.
Image Type	Specifies the icon style. Default: Dropdown (a down arrow).
Visibility	Controls when the dropdown is visible: Always, On Selection or On Edit.
Command	Displays the type selected in Cell Dropdowns. You can update the command directly without reopening the menu. If “[object Object]” appears after selecting a value, open the Numbers tab, choose Custom and apply the correct format using the PROPERTY parameter (for example, =PROPERTY (@, "Month")) to display a month.
Image Src	Allows the use of a custom icon instead of the default one. (Not available in this release).
CaptionAlign	Sets the alignment of the caption. Default: Right.
Image Width and Height	Defines the size of the icon inside the cell.

Command settings

All commands open a configuration dialog using the ellipsis button. Each dialog provides options specific to the selected dropdown type.

Command	Description
Color Picker	Edit theme and standard colors using the color dropdowns.
List	Use Multi-select to allow selecting multiple items. Value Type is String by default. Choose Array when multiple values are stored in a data source. Edit the list structure by hovering next to an item and selecting an option.
Month Picker	Choose the start and end year, and set the height.
Slider	Set the minimum and maximum values and configure tick marks.
Time Picker	Define the minimum, maximum, and step (time interval) in hours, minutes, and seconds.
Workflow List	Reorder items and assign actions. Add new items and select an action if needed.
Multicolumn List	Select the data source, then click Add to create Binding Info Items.