Sometimes, you just need to know how to do one thing in Excel and tutorial such as this is just what you need. However, if you find yourself always looking up how to do things and spending longer looking for solutions than actually using them then you should consider a Microsoft Excel Training course. Our courses are tailored for all ability levels; we run public Beginner Excel training and Advanced Excel training but can also tailor a course specifically to your requirements. Call us on 01273 622272 to discuss the level of training suitable for you.

Using a drop down list in Excel can make data input a lot easier – after all, you don’t want to waste time typing in the same thing again and again!

Preparing Your Excel Drop Down List Data

To start with, let’s make a list. Writing it out in alphabetical order can help, as the cell order is the order in which they will appear in the drop down list (the drop down list won’t automatically reorder itself). In this example, we’ll be using a list of flowers.

First, we write out our flower names in cells A1-A7:

Creating the drop down list

Read the rest of “How to Create Drop Down Lists in Microsoft Excel”