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