Data

Episode 383 – Dependent Validation

               

Setting up data validation lists, where the second list is dependent upon the answer given in the first dropdown box. Episode 383 shows you how. 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(…)

Episode 381 – Indiscriminate Validation

               

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.(…)

Episode 359 – Circular Data Entry

               

A great call from Georgia – how to ease the data entry when you need to enter cells in an unusual pattern. Even if your data entry cells are in a circle or other strange path, you can define a named range that will remember the sequence for entering cells. Episode 359 shows you how.(…)

Learn Excel from MrExcel