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. Top Tech Conferences & Events to Add to Your Calendar in 2023
#Ms excel drop down list how to#
How to Create a Local Account in Windows 11 Pro Support for these Microsoft enterprise products ends in 2023 Image: Imam Fathoni, Getty Images/iStockPhoto Must-read Windows coverage 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)
