Last updated 6 december 2023.
How to insert drop down list in an excel cell. Web computer android iphone & ipad create a dropdown list in google sheets, open a spreadsheet. Select the data tools group from the data tab. In the resulting dialog, make sure the my table has headers option is selected, and click ok.
In the dialog, set allow to list. In the source box, enter the formula that indirectly refers to table1's column named items. Web simply click any cell in the list and press ctrl + t.
Web on the ribbon, click data > data validation. Web how to create drop down lists in excel 1.