Excel Data Validation Update

I've finally updated my Data Validation intro video, so it shows the steps for creating a drop down list in Excel 2010, instead of Excel 2003. These instructions apply to Excel 2007 too, in case you're using that version.

In honour of this momentous occasion, here are links to a few of my previous Excel Data Validation articles and posts. You probably know all the basics, but maybe you've missed a few of these tips and tricks.

Note: Remember to vote for the Excel functions that you'd like to learn more about during the 30 Excel Functions in 30 Days challenge, starting January 2nd.

Watch the Excel 2010 Drop Down List Video

The shiny new video is below, in case you'd like to see that too.


You may also like...

3 Responses

  1. Gerald Strever says:

    I’m glad to see that at least the two of us are busy between Christmas and New Year, keeping our respective economies going. Great blog – keep up the good work in 2011. Best wishes for a productive and prosperous 2011. Kindest regards.

  2. Thanks Gerald! Happy New Year to you too. Now back to work!

  3. Angela Felton says:


    This works great for same cell comma delimited, until you protect the worksheet then it stops working?

Leave a Reply

Your email address will not be published. Required fields are marked *