WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How can we create a drop-down list

Uploaded time: August 27, 2021 Difficulty Beginner

How can we create a drop-down list

How can we create a drop-down list

How can users quickly enter information in the table according to standard content?Drop-down listcan help us to do that.

Take this table as an example. Now we need to perfect the data in the Gendercolumn. We can easily do that by using the drop-down list.

1. First, select the C2: C16 cell range.

2. Then click theInsert Drop-Down Listbutton in theDatatab.

3. We can select theAdd choices drop down manuallybutton in the popup dialog box and enterMalein the text box below.

4. Then click the green Add button on the right. Now continue to enterFemalehere.

5. After adding, clickOK. Now a drop-down arrow will appear on the right side of the selected area.

6. At this time, we can click the arrow to select the properGenderinformation that needs to be filled in.

We can use theSelect choices drop down from cellsfeature if there is too much input.

1. Select the B2: B16 cell range, and select theSelect choices drop down from cellsbutton.

2. Click the collapse button on the right side of the edit box, then drag the mouse cursor to select the F2:F9 cell range.

3. Use the existing content as a candidate item, and then clickOKto quickly make the country information into a drop-down list.

This video could be also used in Microsoft Office Excel and Openoffice. What a practical feature! Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.