To create the Region list, do the following: To the right, you see labels and formats in preparation for creating the Excel drop down list. The second Excel drop down list will display the representatives in that region. The first Excel drop down list will set the condition, the region. (Notice that the region list is in alphabetical order from left to right-it’s the only true limitation on this technique.) Representatives are listed for each region, and some of those representatives are listed more than once-I did that on purpose because it makes no difference to the technique.įigure A We’ll create two Excel drop down lists based on this simple data set. If it doesn’t work for you, try embedding drop down controls instead.įigure A shows a simple matrix-type data set listing representatives in each of the four regions. Once we’re done, you’ll see that this solution isn’t perfect, but it is super easy to implement. If you Google, you’ll find complex and sometimes even convoluted solutions. I’m showing the simplest technique, but it’s not the only technique. Note: This technique works only with a matrix-style data set. You can work with your own data or download the demonstration. A situation like that requires two drop downs: One that lets you specify the region, and the second that displays only the staff in that region. You want to work with personnel by region, not all personnel. Let’s suppose you have personnel scattered across four regions: North, south, east, and west. You can use a Microsoft Excel drop down list to display a simple list, though sometimes you need a bit more control. Image: Imam Fathoni, Getty Images/iStockPhoto Must-read Windows coverageĭefend your network with Microsoft outside-in security services For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships.
Microsoft Excel users, here's a quick tip on adding a condition to a drop down list. How to add a condition to a drop down list in Excel
0 kommentar(er)
