CREATE A DROPDOWN LIST IN EXCEL

A useful skill to have – particularly if you need to do analysis on a list (in pivot tables etc) as you want to ensure that your data entry is kept consistent. It’s also a real time saver it you need someone else to input data for you and you want to...