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 “Gender” column. 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?