For example, A 1 cell is used to pull down Beijing, Shanghai, Tianjin and Wuhan.

Select a1> Data > data validity > permission > sequence > source: fill in Beijing, Shanghai, Tianjin, Wuhan,

Note that place names should be separated by commas, and never use Chinese commas!

After confirmation, a drop-down arrow will appear in A 1. Click to realize selective input, and the drop-down menu is finished.

09436044482579.html