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:
Post a Comment