Using Excel to complete the form, one-click information is filled in.

The teacher in charge of the enrollment work needs to fill out a comprehensive information form for each student and print it into a paper file, because the form involves the student. The basic information and the scores of the six semester subjects are very large. The author summarizes a set of efficient filling methods, which can be completed with one click. Tip: For spreadsheets from all walks of life, report generation and printing involving multiple source table data can be modeled after this method. Xiaobian recommended: "Microsoft Office 2015 download" 1. Organize the original data to open Excel 2010, create a new workbook, and provide students with the "Basic Information" and the students provided by the Academic Affairs Office for six semesters. The results are organized and copied into this workbook (Figure 1). 2. Create a print template Insert a worksheet into the same workbook and create a consistently formatted template (Figure 2) as required. 3. Achieve one-click fill in the student ID is unique, the "basic information" table of the student ID number to define a name, easy to print a template to fill in a key. Click the “Basic Information” worksheet, select all students' student ID numbers and right click, click “Define Name” in the shortcut menu that pops up, and enter the name “xjh&rdquo” in the “New Name” window. ; In the "Print Template" worksheet, click the C4 cell, then click "Data Validity" in the "Data" menu, and click the "Settings" tab in the pop-up window. Set the 'allow"condition to "sequence" and enter “=xjh” (Figure 3) in the text box below "Source". Tip: In the data validity condition, the data in other worksheets cannot be directly quoted as the source, so the student's “student number” in the “Basic Information” field is defined as a name ““xjh”, convenient&ldquo ; print template " reference in the worksheet. In the "Print Template" worksheet, click on the C3 cell and enter the formula <==VLOOKUP(C4, Basic Information! A2: J11, 2, FALSE)”. For the same reason, enter the corresponding formula in other cells that need to fill in the information, such as entering “=VLOOKUP (C4, high one! A2: M11, 3, FALSE) in the C11 cell. Click the C4 cell in the “Print Template” sheet, and then click the drop-down arrow on the right to select the student ID number below, and other relevant information will be filled in automatically (Figure 4). Then you can print it. This article comes from [System Home] www.xp85.com