To create a drop-down validation list that spans two columns in MS Excel, follow these steps:
Select the cells in which you want to create the drop-down list.
Click on the "Data" tab in the Ribbon.
Click on "Data Validation" in the "Data Tools" group.
In the "Settings" tab, select "List" from the "Allow" drop-down menu.
In the "Source" field, enter the values you want to include in the dropdown list, separated by a comma. For example, "Red, Blue, Yellow".
Click on the "OK" button.
Now, the cells will have a drop-down list with the values you entered.
To span the drop-down list over two columns, select the cells in the second column and go back to the Data Validation window.
In the "Source" field, add the same comma-separated values as in the first column, but with an ampersand symbol (&) and a space before the first value. For example, "Red, Blue, Yellow" becomes " & Red, Blue, Yellow".
Click on "OK" and the drop-down list will span both columns in the selected cells.
Note: If there are more values in the second column than in the first, the drop-down list will display the additional values only in the second column.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-05-14 18:17:55 +0000
Seen: 11 times
Last updated: May 14 '23
How to perform batch geocoding when longitude and latitude values are missing?
How can a new object with a specific type be created in Angular 2 using the domain model?
What is the method to eliminate NA from facet_wrap in ggplot2?
How can a text/varchar column be shortened when duplicate values are not permitted?
How are `all: unset` and `all: revert` dissimilar from each other?
How can I set values on a Map using more than one parameter from a nativeQuery?
What is the problem encountered when attempting to filter the column values of a data.frame?
How can an array be filtered using the values in another array?