Sometimes you want to have cell validation, but you need a way for the person using the spreadsheet to override the validation list, especially in the case where there is a brand new value that you have not yet added to the list. Episode 381 shows you how to have the Validation dropdown ease up.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!