![]() ![]() You can either click the down arrow to select from the list, or you can begin typing a value in the cell.Ĭlick here to watch this video on YouTube. Click Save and return to the original worksheet.Select Reject Input if you’d like to prevent any value not in your list.Set Criteria to be “”List from a range”” and select the values you entered on the Values worksheet. ![]() ![]() Right click and select Data Validation.Go back to the original worksheet and highlight the cells where you’d like the drop-downs to appear.Enter the values you want to have appear in your drop-downs.Create a new worksheet and name it Values.You can create an editable copy by clicking ‘File’, then ‘Make a copy’. To see the sample document featured in the video, click here. The video above will guide you through the following steps. This feature is very useful for controlling what collaborators can enter into cells and for allowing you to enter values very quickly, by simply typing the first character or two of a value and then pressing Enter. Set the criteria range E2:E10 and voila Your dynamic drop-down list in Google Sheets is ready. ![]() But, did you know that you can create custom drop-down menus with data validation? To do that, go to cell B2, then go to the menu Data > Data Validation. Data validation is one of our favorite tools in Google Sheets, because it gives the Spreadsheet owner even more control over the data that’s entered. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |