Click "Data" and "Filter" in turn, check the "Blank" option in the drop-down menu to filter out all blank lines, and then click the "Delete" button, and you will find that all blank lines are bound!

By the way, don't forget to cancel the Auto Filter in the Filter menu again.

Pattern search solution-find what you need in a few minutes.

In daily work, it is often necessary to search for a certain kind of regular data. Is it too much trouble to search accurately?

Don't be afraid! Let wildcards help you with fuzzy search!

In Excel, "?" You can replace any single character in the search target, and "*" can replace any number of consecutive characters.

For example, I want to search for cells that start with "a", enter "A*" in the search and check "cell matching".

Please remember the general search table below!