Step 4: Next, enter all the items that you want to appear in the list separated only by a comma in the second box next to Criteria. We will go with List of items to keep it simple. The second option means users can choose a list of items from other cells in the same sheet or even other sheets within the same document. The first option means users can choose an item from a predefined list of items. Step 3: In the pop-up that follows, select criteria which can be either ‘List of items’ or ‘List from a range’. Step 2: Select Data validation under the Data menu. Step 1: Type sheets.new in the address bar to create and open a new Google Sheets document quickly or open one from your Google Drive account. That said, Google recommends Chrome browser for best results. We tried the Edge browser on a Windows machine and you can use this any browser on both Windows and Mac. Create Drop-Down List in Google Sheets in Web App
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |