How Excel deletes blank lines

In Excel, to be beautiful, you want to remove blank rows from your worksheet. You can delete blank rows from a table in the following ways.

1. Select any cell in which you want to delete the blank row worksheet, and then select Insert → column, where a column is inserted to the left of the selected cell. For example, the new insert is column F, and an integer is entered in column F.

2. According to a random column in the table, sort the rows in the table so that all the blank rows are at the bottom of the table, and then reorder the F columns in all empty rows, and then delete the F column.