Function Problems

How to Create a Two-Column Selection List in Excel

Khadija Khan Oct 10, 2026 869 views

Question details

The user needs to display two columns of information, such as an object code and its description, within a single selection drop-down list.

How to Create a Two-Column Selection List in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Setting up forms or tables where users must select values based on both an identifier and its explanation.
Observed behavior: Excel's standard data-validation drop-down lists natively display only a single column, making it impossible to directly show codes and descriptions together.

Before you start

Ensure the Developer tab is enabled in your Excel ribbon, as you will need it to insert form controls like the ActiveX Combo Box.

Solution 1Recommended

Use an ActiveX Combo Box

An ActiveX Combo Box is the most robust native method to display multiple columns in a single drop-down without altering your original data structure.

Since standard Data Validation limits you to one column, inserting a Combo Box control allows you to specify a multi-column range. This is especially useful for pairing short ID codes with longer text descriptions so users can see full context before selecting.

Insert the Combo Box

Navigate to the Developer tab, click on 'Insert' in the Controls group, and select 'Combo Box (ActiveX Control)' under the ActiveX Controls section. Draw the box on your worksheet.

Open Properties

Right-click the newly drawn Combo Box and select 'Properties' from the context menu.

Configure Multiple Columns

In the Properties window, locate the 'ColumnCount' property and change its value to 2.

Set the Data Range

Find the 'ListFillRange' property and type the range containing your two columns of data (for example, A2:B20).

Link to a Target Cell

Set the 'LinkedCell' property to the cell where you want the selected value to be recorded, then close the Properties window and click 'Design Mode' on the Developer tab to activate the drop-down.

Adjusting Column Widths: You can adjust the display width of each column in the drop-down by modifying the 'ColumnWidths' property in the format '50 pt; 150 pt'.

Solution 2

Use a Helper Column with Standard Data Validation

If you prefer not to use Developer controls, you can concatenate the two columns into a single helper column and use standard Data Validation.

Advanced Data Management

Create Custom Drop-Down Lists Easily in WPS Spreadsheet

WPS Office provides excellent support for advanced data validation and form controls, allowing you to build complex selection lists and data entry forms without frustration.

1. Open your spreadsheet: Launch WPS Spreadsheet and open your existing data file.
2. Combine your data: Use a formula like =A2 & " - " & B2 to merge your two columns into a single helper column.
3. Apply Data Validation: Go to the Data tab, click the Validation icon, select List, and highlight your new helper column to create an easy-to-read drop-down.

Seamless compatibility with Microsoft Excel (.xlsx) formatsFully supports text concatenation for multi-column drop-downsFree, lightweight, and fast-loading spreadsheet applicationIntuitive UI that requires no learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select two columns in standard Excel Data Validation?

Excel's built-in Data Validation list tool is fundamentally designed to read and display only a single column or single row of data. To visually present multiple distinct columns, you must rely on advanced form controls like an ActiveX Combo Box.

How do I hide the helper column after creating my combined drop-down?

Right-click the column letter header containing your combined formula and select 'Hide'. The drop-down list will continue to function normally while keeping your main worksheet looking clean.

Can I use VBA to create a searchable two-column drop-down?

Yes, you can build a custom UserForm using VBA that includes a ListBox or ComboBox configured for multiple columns. This allows for dynamic searching and data entry, though it requires some programming knowledge to set up.

Excel & Data Problems