1, open an Excel table first. Enter the title of the people list in cell A 1.
2. Secondly, enter the serial number, name, age, place of origin, date of birth and other information on the right side of cell A2. Select multiple rows from the drop-down box to add table rows.
3. Finally, adjust the width of each column according to the contents to be filled in the table. Select the entire title and center the text. Merge the title lines, adjust the title font size to 20, and the personnel list table will be ready.