Cell Dropdowns

You can add a dropdown menu to a cell to help select values quickly. This feature is useful for building strructured forms, form controls, or interactive dashboards within a spreadsheet.

Several dropdown types are available depending on your needs. You can use them to select from a predefined list, perform calculations, choose dates or times, pick colors, adjust values with a slider, or display dynamic options based on earlier selections.

Cell dropdown types

The following dropdown types are available to populate cells:

Cell DropDown	Description
Calculator	Computes values and enters the result in the cell.
Color Picker	Lets you select a color to populate the cell with the color's hex code.
DateTime Picker	Sets a date and time.
List	Displays a list of predefined values to choose from.
Month Picker	Lets you pick a specific month of the year.
Slider	Adds a dynamic range slider that returns the current value.
Time Picker	Sets a specific time.
Workflow List	Shows workflow options that change based on previous selections.
Multicolumn List	Combines a dropdown list with an editable input field. You can scroll and select an item. The selected item is returned, and stays highlighted when the dropdown is reopened.

Create a dropdown list

1. On the Home tab, in the Styles section, select Cell Editors > Cell Dropdowns, then choose the dropdown type you want.
2. In the Format Cells dialog, the Cell Button tab opens by default. All dropdown types share common parameters. Some types include additional options.
3. Enter parameters under Cell Button.
4. 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 described in the creation procedures.

Remove a cell dropdown

1. Select the cell.
2. On the Home tab, in the Styles section, select Cell Editors > Cell Dropdowns > Clear CellType.

Cell button parameters

Parameter	Description
Command dropdown	(button list on the left) Shows the dropdown type selected in the Command list. It reflects your choice from the Cell Dropdowns menu. Click Add to insert more dropdowns and assign a command to each one.
UseButtonStyle	Makes the cell look like a button.
Position	Specifies the position of the dropdown icon in the cell.
Width	Sets the width of the dropdown.
Caption	Optional label that appears beside the icon.
BackColor	Sets the dropdown background color.
Hover BackColor	Sets the background color when the cursor hovers over the dropdown.
Image Type	Defines the dropdown icon type. By default, Dropdown is selected (a down arrow).
Visibility	Controls the dropdown visibility: Always, On Selection or On Edit.
Command	Shows the type selected in the Cell Dropdowns menu. You can change the command directly without reopening the menu. If “[object Object]” appears in the cell after selecting a dropdown value, open the Format Cells popup from the Numbers menu. Choose Custom and enter the correct format using the PROPERTY parameter, such as =PROPERTY (@, "Month") to display a month value.
Image Src	Lets you use a custom image instead of the default icon. (Not available in this release).
CaptionAlign	Sets the caption alignment. By default, Right is selected.
Image Width and Height	Sets the icon size inside the cell.

Command parameters

Command	Description
Color Picker	Click the ellipsis button to open the dialog. Edit theme and standard colors using the color dropdowns.
List	Click the ellipsis button to open the dialog. Use Multi-select to select multiple list items. Value Type is String by default. Use Array for multiple values in a data source. Edit the list structure by hovering next to an item and selecting the desired option.
Month Picker	Click the ellipsis button to open the dialog. Select the start and stop year, and set the height.
Slider	Click the ellipsis button to open the dialog. Set the minimum and maximum values and define tick marks.
Time Picker	Click the ellipsis button to open the dialog. Set the minimum, maximum, and step (time interval) in hours, minutes, and seconds.
Workflow List	Click the ellipsis button to open the dialog. Order list items and assign actions to each. Add new items and select an action if needed.
Multicolumn List	Click the ellipsis button to open the dialog. Select the data source. Click Add to add Binding Info Items.