How do I get a drop-down list in an Excel table?

Source: Internet
Author: User

I would like to fill out some optional content in the Drop-down list, so you can directly select the mouse input, please tell me the method, thank Gege!

Question added:

I can make this triangle, but I'm not going to enter it in the triangle.

Data--validity--sequence, enter the item you want to select in source, and you can separate it with a comma with a half. Male, female "

Of course, you can also enter the item you want to select in one area of the worksheet, and then in the Open Data Validation dialog box, after the "source"

Select the range of cells for which you have entered an alternative.

Supplementary answer: Enter those alternatives in the "source", such as "first grade, second grade, third grade", and these alternatives are separated by a half-width comma. It would be nice to be sure.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.