Creating simple drop-down lists in Excel

Recently I’ve had a few requests on how to create drop-down lists in Excel. These are really useful as (a) they are time saving; the user chooses from a pull-down list instead of laboriously typing out cell entries, (b) they prevent typing errors, as the text is already there and (c) you can force users to only select entries within the bounds of a list. There are different methods of creating drop-down lists, but in this short video, you’ll learn the simplest method.

Scroll to Top