Monday, March 16, 2015

How to add a dropdown menu in a Google spreadsheet

I love finding shortcuts, and here's one of my favorite ones in Google Sheets.  If you find yourself typing the same stuff in a specific column, or want to be sure that the multiple people editing your sheet use the same consistent language, make a dropdown menu! We use this in some of our training spreadsheets with things that are the same, like department names.  For example:

The benefits are not just ascetic. It also makes it *much* easier to use your sort functions and get the needed results.  It also makes you look like a rock star when you are able to pull up a neat, organized worksheet on the fly in a meeting.

How do you make this amazing drop down?  I'm so glad you asked.  Here's a step by step video just for you!

No comments: