Joke Collection Website - Mood Talk - Blank lines in excel, if merged?

Blank lines in excel, if merged?

Let me tell you something:

1. Select a column next to this column (if the data in this column is useful, you can also insert a new blank column) as a temporary column, and select the area from the beginning (enter a 1) to the end (for example, the length from the first Beijing to the last Shaanxi in the table).

2. Select Edit-Fill-Sequence-Sequence generated in the column-arithmetic progression-Step value 1- End value and leave it blank. Of course, there will be numbers like 1, 2, 3 ... in this column, its function is to save the original arrangement order.

3. Select the column that contains the text and sort it.

4. At this time, the blank lines are arranged together (but the order of characters is also arranged together, which is usually automatically sorted by Pinyin), and you can choose to delete them at one time.

5. Restore the original order, select temporary columns and sort them.

6. Delete the temporary column number, select all columns and press Del.

7. done.