Digital collaboration · Digital communication, collaboration and participation (participating) · Digital creation · Digital creation, innovation and scholarship (creative production) · Digital research and scholarship · Excel · ICT proficiency · Microsoft Office · Windows · Working with Data

#126 Create drop-down lists in Excel for zippy form entries

Drop-down list can be super useful, particularly when you are analysing or form filling. They help to keep consistency across your document (useful if you are working collaboratively) and helps to speed up the time it takes to fill in the data.

In this post I’m going to show you how to set up drop-down lists in Excel (in less than a minute, that’s how easy it is!).

Featured Image: “zip” by Magne Hagesæter licenced under CC BY-NC-ND 2.0


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s