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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s