Add an Excel drop-down validation list

By Jetformat

Provide a range and a comma-separated set of allowed choices. This creates a worksheet rule rather than repairing values already stored in the range.

Steps

Start with a local XLSX. Replace the sample paths and identifiers with your own.
Run the command below. Save to a new output path so the source remains available for comparison.
Check the result as described below before using it in another job.

jetformat excel validation finance.xlsx --sheet Summary --range A2:A10 --list Ada,Bob -o finance-updated.xlsx

Options for this task

Option	Meaning
`--list`	Comma-separated drop-down options
`--output`	Output XLSX path (required)
`--range`	Range, for example A1:A10
`--sheet`	Worksheet name (required)

Check the result

Open the output in a viewer, test the drop-down, and separately audit existing cell values against the allowed list.

Notes and limits

Writing an Office document uses one credit per command. See the billing guide for the current rules.

The examples keep the original file. Add --force only when you intend to overwrite an existing output. Run jetformat excel validation --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.