order to achieve rapid entry and avoid past confusion of statistics in the format in Excel 2007 worksheet middle school students where the class where the department and are ready to use the drop-down list in the form of input. School is divided into four sections, each has more than 10 classes. If the information in a list, now, to be sure a lot of trouble. Therefore, planning departments, with a list of all classes, while the department entered, it corresponds to the list of only the sections of the class, not the school for all classes.

tested, I use the definition of sequence so that the problem was quickly resolved, the data entry work and therefore a lot easier.
First, the establishment of basic data table

First, we select a worksheet, double-click its sheet tab, be renamed the "basic data." Then followed by four sections of the class name of the column were entered in the A to D cell column, a column for each department separately. Department's name can be placed on the top row of the column. In cell E1 type "sections" and below the cell in its various departments in the name of each entry. Shown in Figure 1.

Figure 1

$ show_page $
A selected column range of cells, and then click the function area "formula" tab, "the name of the definition of" functional group "definition name" button on the right side of the small triangle in the pop-up menu, select "custom name" command, open the "New Name "dialog box, shown in Figure 2. Confirmation dialog "Name" input field for the "Computer Studies" and press the OK button to close the dialog box. This column A range of cells can be defined as "Computer Studies" of the.

Figure 2

Using the same method selected B, C, D columns, respectively, the sections were defined corresponding range of cells.

selected sections where the E column, the column area is defined as "departments."

Second, use the sequence to achieve fast and accurate entry

now back up to the task table to table as an example shown in Figure 3. Select B2: B6 range of cells, click the function area "Data" tab "Data Tools" functional group "data validation" button on the bottom right corner a small triangle, the pop-up menu, select "data validation" command, open the "data validity "dialog box.

Figure 3 $ show_page $

click the dialog box "Settings" tab, in the "Allow" drop-down list, select the "sequence", and "source" under the input box, enter "= INDIRECT ($ B $ 1)", such as Figure 4.

Figure 4

select the C2: C6 range of cells, is still open "data validation" dialog. All the same settings as shown in Figure 4, which is to "source" in the formula was revised to "= INDIRECT ($ B2)". Should pay attention to the way the formula references different.

After this twisted setting, when we positioned the mouse B2: B6 region of a cell, it will appear in the drop-down button on the right side of the cell, we can choose in this drop-down list, enter the department name. We click the C2: C6 cells in the region of a drop-down button will display the current sections of the class list, shown in Figure 5.

Figure 5

use this method, you can quickly and accurately complete the data entry, convenient and effective.