Web how to create drop down lists in excel 1.
How to insert drop down list in an excel cell. In the source box, enter the formula that indirectly refers to table1's column named items. In the source box, either update. Web simply click any cell in the list and press ctrl + t.
Select the data tools group from the data tab. Web on the ribbon, click data > data validation. If you don't want users to.
In the dialog, set allow to list. Web computer android iphone & ipad create a dropdown list in google sheets, open a spreadsheet.