Then, choose either Dropdown or Dropdown (from a range) under the Criteria selection. View more cell actions > Data validation Step 2: Add Drop-Down Optionsįrom the data validation rules menu, select +Add rule Note: you can also add a data validation rule by right-clicking on the cell, then choose: Then go to the menu: Data > Data validation Select the cell where you want to put a drop-down menu. It only takes a few steps to create a drop-down list in Google Sheets, using the Data Validation tool. How To Create A Drop-Down List In Google Sheets In this post, we’ll explore both of these techniques with examples.īut first, let’s see how to create a Google Sheets drop-down menu. Here’s an example of a drop-down menu to record the status of deals in a real estate deal pipeline:ĭrop-down menus are great for data entry and making your Sheets dynamic. In this post, we’ll look at how to create a Google Sheets Drop-Down Menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |