How to delete tens of thousands of blank columns in EXCEL tables?

Use the search function to find an empty line and delete it. Let's briefly demonstrate the operation steps.

Computer: MacBook Air

System: macOS 12

Software: WPS6.0. 1

1. First, we open the Excel table of WPS, and we can see that there are many blank lines on the left. Click search in the upper right corner.

2. Then we click on the location of the list.

3. Select a null value here, and then click Locate.

4. Then right-click any blank line on the left.

5. Select Delete and click the entire row.

6. In this way, the redundant blank lines are deleted, as shown in the figure.