1. Quick check and cross

First, select all the cells to be set, click Data-Data Validity, then click Settings-Sequence, and enter "√, ×" in the source.

2. Quickly recover the garbled code

Select the area to be restored-right mouse button-format cells-click Custom-change the type to "0" and click OK.

3. One-click beautification form

Press "Ctrl+A" to select all tables, "Ctrl+T" to create a super table, select "Tables with titles" and click OK.

4. Add units in batches

Select all tables, set cell format-custom-common format and enter "minutes" for confirmation.

The positions of these two columns are reversed.

Select the list to adjust, place the mouse on the border of the column, and hold down Shift. When the mouse changes to the up and down arrow, drag it directly to the position to be adjusted.

6. Enter the serial number of 10000.

Enter the serial number 1 first, then click Start-Fill-Sequence-Select Column-End Value, and enter 10000.

7. Draw a single diagonal title

First, adjust the row height of the table, enter the date and name, press "Alt+Enter" before the name, press the space bar before the date to adjust to the far right of the cell, right mouse button-format the cell-border-click diagonal-click OK.

8. Change the background color of the photo.

Click Insert-Picture-Find the prepared picture-Click OK-Select the photo-Change the height and width of the photo to 2cm, click Picture-Picture Format-Delete the background, mark the area to be preserved-Draw the area to be preserved with a brush, and then select the photo-Click Start the color filling below and fill it with the required color.

9. Delete comments in bulk

Select all tables, press "Ctrl+G" to bring up the positioning-click the positioning standard to select "Label"-OK, and then press the right mouse button-delete the comment.

10. Horizontal table conversion

Select all contents, copy, select a blank cell, right click-Paste Special-Check Transpose-OK.