Tools/materials: Dell XPS 13-9350-3708, win 10, excel20 19.

1. Select the column label to hide at the same time, press the left mouse button and drag it to the left quickly to hide the selected column. Select multiple column labels with hidden columns at the same time, and double-click the mouse to unhide the columns.

2. There are too many data in the table to check. Double-click the cell border to quickly jump to the bottom or top.

3. Select a column, hold down the Shift key and drag the border to quickly adjust the positions of the two columns.

4. First select a part of the area, then hold down the Shift key and double-click the cell border to quickly select the area before or after the current area.

5. Before sorting the table, please enter consecutive serial numbers in the blank column. After the sorting operation, sort the serial number column in ascending order, which can quickly return to the previous state.