In Word or Excel, for some projects, relatively fixed input, such as gender input, job title input, etc., if you use the drop-down list to select items to enter, it is much more convenient than manual input. How to achieve it? Excel implementation of the drop-down list to select the entry example description: in the personnel information entry form, such as gender to fill "old" male /rdquo; or "female", political face to fill "people" & rdquo; or "members", rdquo;, title To fill in one of the “high school, middle school level, middle school level, and class level”, these are all entered one by one, so making a drop-down option directly can save manual re-entry. First, type what you want to display in the drop-down list in any column. Then, select the area you want to use to select the input using the drop-down list, and then click the “Data & Rarr; Validity” command, in the “Data Validity” form, select the “Settings” tab, in the “Settings” tab, in “ In the Allow & rdquo; column, select “ Sequence& rdquo;; in the "Source" column, click the data area selection button on the right, and use the mouse to select the content cell to be entered in the drop-down list. Finally click “OK” to return (Figure 1). At this point, just use any cell in the area of the mouse to click, a drop-down arrow will appear next to the cell, click the arrow, it will display all the setting sequence, we just click the desired item to complete Enter (Figure 2). Word implementation of the drop-down list to select the input in Word, we sometimes need to add some data in the form, but there is no data validity setting in Word, we can change the idea to achieve. Example description: Fill in the corresponding grades and corresponding teaching subjects in the form of the Word document. The grades include the first grade, the second grade, and the third grade. The subjects include language, mathematics, and foreign languages. Drop-down form fields in Word are often used for alternative situations. We design this form, you can use the drop-down form field in the "teaching department, the grade level", users can click the mouse to select when filling out the form, no need to input, eliminating the need for repeated input. First, insert a drop-down form field. Move the mouse to the specified position, such as the cell below the "Year" level, point & ldquo; view → toolbar & rarr; form & rdquo;, pop-up "form" folder, point & ldquo; drop-down window Body & rdquo; button (Figure 3). When the form field is inserted, a small square is displayed in the cell (the shadow is displayed when the "form field shading” button is pressed). The form field shading is only displayed on the screen and is used to remind the user of the specific location of the field and will not be printed. Double-click the inserted form field and add the option in the drop-down menu in the box that pops up in the "Drop-down form field option" in the "Drop-down" box. Check the “Enable drop-down list" item, and click the "OK" button (Figure 4). The drop-down form field of such a cell is set, and the following cells can be copied and pasted. And so on, complete the domain insertion work of other items. Then, protect the form. After the drop-down form field is inserted, click the small lock-like "protect form" button on the "Forms" toolbar, so that no part of the table can be used except for the cell containing the form field. to modify. At this point, click any form field cell with the mouse, and a drop-down small arrow button will appear on the right side of the cell. Clicking this button will pop up a drop-down list and select it. Once you have selected all, click the “protect form” button to unlock it. In this way, the data can be filled in quickly. There is only some less perfect place, that is, after unlocking, there is a border around the text on the view, but it is not printed. This article comes from [System Home] www.xp85.com