Remove value restrictions in excel for mac

broken image

I’m going to walk through three different ways to accomplish this:

broken image

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.”

broken image

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.

broken image

Originally written by Analytics Demystified on May 10, 2011