That brings us to… My Standard Way - Data Validation with a Named Range Going in and updating the available list of values is a real pain. The Limitation: Suppose that you decided you wanted to add a new value to the list of options, and that, rather than four cells right next to each other, this same data validation rule was used across numerous non-contiguous cells, even cells across multiple worksheets. Repeat for each set of cells that has a unique set of dropdown value options.Enter the values in the Source box (separating different values using commas).Select Data » Data Tools » Data Validation.
The quickest way to set this up is with basic data validation: The wrinkle is that you expect this list to live for a while, and there’s a good chance that you may want to have other values available for either the Priority or the Status columns (or both). For instance, let’s say you’ve made a list of household chores, and you use that list to both assign a priority to each task as well as to note the status of the work:įor both the Priority and the Status column, you’d like to enter the values using a dropdown menu, rather than needing to retype a value in each cell: You’re using Excel to enter a table of data, where one or more of the columns have a standard set of possible values. The way I may start doing it (sometimes), which would make the approach just that much slickerīounce around as you see fit! The Scenario.The way I always do it - almost no more effort to implement than the first way…but with fewer limitations.The totally common, mundane way - straightforward, but it has limitations.I’m going to walk through three different ways to accomplish this: In the course of showing her, I realized that, therein, was one of those handy little tips worth sharing.
This came up last week when a co-worker asked me: “How do I get dropdowns working in cells in Excel?” She knew she had done it before, but she couldn’t remember how. This is just a good ol’, “Hey, let’s look at a handy capability of Excel…and how to use it to the best of its ability.” So, this post is not about the latest turn in world of privacy legislation, it’s not about my deepening fascination with two-tiered segmentation, it’s not about the perplexing and depressing indefinite postponement of Demystified Days, and it’s not even about pondering when Team Evil Forces will have a web site. I recommend reading that one rather than this one.Įvery once in a very rare while, I find myself not motivated to expound upon deep and meaningful subjects. NOTE: There is an updated version of this post posted here. Originally written by Analytics Demystified on May 10, 2011
0 kommentar(er)
