Display Multiple Columns in a Validation List in Excel
In this article we will show you how to display multiple columns in a validation list in Excel.
Example to show the range A1 to C20 (20 rows and 3 columns).:
Start by naming the range A1 to A20 as "List" then highlight A1 to A20 and following the procedures outlined below:
Image © Dzmitry Kliapitski -123rf.com
Create a Validation List With Multiple Columns
We'll need to trick Excel to accept to create a validation list with multiple columnsExample to show the range A1 to C20 (20 rows and 3 columns).:
Start by naming the range A1 to A20 as "List" then highlight A1 to A20 and following the procedures outlined below:
Excel 2003 and earlier version
- Insert / Name / Define
- in the Name text box in the workbook: name the range as list
- create a list of validations in E3 (Data / Validation, in Allow: select "List" in Source: type =List)
- Open the Name manager Insert/Name/Define, select the name of the range (List)
- In "Refers to": Change the values from $A$1:$A$20 to $A$1:$C$20
Excel 2007 and above
- Data tab / Data Validation module
- In the name text box : name the range as List
- Create a list of validations in E3 (Data/Validation, in Allow: select "List" in Source: type =List)
- Open the Name manager: Formula tab/set name/Name Manager, select the name of the range (List)
- In "Refers to": Change the values from $A$1:$A$20 to $A$1:$C$20
Image © Dzmitry Kliapitski -123rf.com
Related
- Excel data validation list multiple columns
- Display multiple columns in a validation list - Best answers
- Excel data validation list from table multiple columns - Best answers
- Multiple if statements in excel data validation - Forum - Excel
- Multiple If in Data Validation ✓ - Forum - Excel
- Using a data validation AND an IF formula in the same cell ✓ - Forum - Excel
- Using excel if function with data validation - Forum - Excel
- Excel IF statement with Data Validation - Forum - Excel
This document, titled « Display Multiple Columns in a Validation List in Excel », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
Subscribe To Our Newsletter!
