1. Open Excel and double-click to create a new Excel table.

2. Select the area where you want to create a new table, right-click and select the cell format. Select the cell, first click the toolbar fill color button, and select the appropriate color; Then click the toolbar font color button, select white, and finally press the Excel shortcut Ctrl+B to make the font bold; You can fill excel tables with colors.

3. Select the Border tab in the pop-up dialog box. Select A 1: E9 cell area with the mouse, click the toolbar border button drop-down triangle, and then select all border lines to add them to the excel table.

4. Select the cell range from Class A to Column E, and click the "Vertical Center" and "Horizontal Center" buttons on the toolbar respectively, so that the excel table can be aligned in the center without being messy.

5. Select the cell range A 1: E9, then click the table style in the toolbar and select the appropriate style to pop up the table style dialog box. At this point, we can click OK to complete the confirmation and add the table style to the excel table. Set the border of the finished table, and then click OK, so that the table is finished.

6. If you need to enter a title, you can select the cell table in the first row. On the menu of the Start tab, click Center after Merge and enter a title and content.