Joke Collection Website - Mood Talk - Blank lines in excel, if merged?
Blank lines in excel, if merged?
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.
- Previous article:Humorous insomnia sentences to talk about your mood
- Next article:High EQ drinks and sends friends to chat.
- Related articles
- Widow Poetry What is Widow Poetry?
- Pride is so important. I knew it.
- On the evaluation of couplets
- What ancient poems are there in summer?
- CCTV and the Communist Youth League sent Weibo to celebrate IG's championship, but some commentators said that e-sports was a cancer. What do you think of e-sports?
- Express tired sentences and talk about your mood.
- Yidong took me around the night show and enjoyed the beautiful night.
- Mood phrases of mother accompanying in hospital
- A summary of 100 sentences of copywriting for posting to Moments for the College Entrance Examination
- Who can talk about the wedding anniversary?