In the drop-down menu, as shown in the image below, select Data validation.ģ. Let’s go over how to add a drop-down list to your Sheet.Ģ. The gif below shows a final drop-down menu and how it applies to the sample data set. I want to create a drop-down menu so I can easily go in and change the status of the campaign as time goes on.īefore going through the steps, it might be helpful to see what a drop-down menu looks like so you can contextually understand each instruction. The example data set for this walkthrough (as shown in the image below) is tracking the progress of marketing campaigns on different channels and the stage they’re in not yet started, in progress, or completed. How to Add a Drop-down List in Google SheetsĪs mentioned above, a drop-down list can help you easily change elements of a cell when the content is repetitive. In this post, we’ll go over how to add a drop-down list to your own Google Sheets data set to help save time. It can get tedious to go in and type each yes or no as time goes on, which is where a critical tool, the drop-down list, becomes your best friend.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |