Step 1: Open excel, create a new page, double-click the small label at the bottom, modify the title, and enter the relevant title in the middle of the first line.
Step 2: Enter the keywords in the second line in turn, usually putting the employee number at the front to facilitate subsequent search.
Step 3: Some cells are filled with duplicate data, and data validity can be set. The specific operation is as follows: select the corresponding column, and change the menu of Data-Data Validity-Settings-Allow to order. You can manually enter the source or select the cell. After the setting is completed, click the cell, and you can select directly without manual entry, so that the accuracy of the data can be guaranteed.
Step 4: After data entry, beautify the table slightly, select the cells and select the border format in the toolbar.
Step 5: Make another student's health account according to the above method, and slightly change the label and header content.