Simply click the arrow and select an option.
How to create drop down list in excel google sheet. On the first sheet, select cell b1. You can also create a dependent drop. Web feb 11, 2023, 11:00 am edt | 3 min read.
Web it’s easy and we’ll show you how. On the second sheet, create the following named ranges. Below this heading, type in the.
Then, click data > data validation. Select the data you want to use and type a name for it in the name. In google sheets, open a spreadsheet.
Type in a heading for your list (for example, region ).