How to format the record table?

Open or create an excel document with blank pages;

Please click to enter a picture description.

Set the table name in the document, and enter the table name after merging the cells;

Please click to enter a picture description.

After setting the table name, set the title and set it in the required format. Examples are as follows:

Please click to enter a picture description.

Format the title, select the title line and add shading color to it, as follows;

Please click to enter a picture description.

Enter a date in the date column, and the drop-down box will automatically fill in all dates;

Please click to enter a picture description.

By adding a border to the table, a record table can be made. The finished product is as follows.

Please click to enter a picture description.