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 comment