Quick Tip... How to use drop-downs in Excel
Access our COMPLETE Excel Course HERE
This Quick Tip tutorial from Essential Excel introduces and walks you through using DROP-DOWNS in Excel.
Drop-downs give you the ability to enforce the values a user can select when providing/ populating data into a worksheet... particularly useful when you are preparing a sheet that will be circulated to collect data from different users.