Use the method to delete empty lines in the Excel table to make the table more refreshing

When we use Excel to statistic and analyze objects, the data entry work cannot be done overnight. The addition, deletion, cutting, and merging of records are indispensable. After many editing and modification processes, there are often many in the table. Blank line. The existence of these blank lines is neither aesthetically pleasing nor affects the results of data analysis, which is usually removed. If there are fewer empty rows in the table, then you only need to delete them line by line, but if the worksheet is large (such as thousands of rows), and there are many blank rows in the table, manually deleting one row and one row will undoubtedly take a lot of time. force. If you are experiencing such troubles frequently, you may wish to try the following methods to clean up the unnamed blanks quickly, cleanly and in batches.
The author summarizes the following three methods, so that you can easily delete the blank lines in the Excel table.

Figure 1 Excel data table
First, the location deletion method
Using the "positioning" function provided in Excel, all the blank lines in the table are located at one time, and then they are exhausted. ”.
Select the “Edit & Rarr; Positioning" menu command, and click the “Targeting" button in the "Location" dialog box that appears, in the "Targeting Conditions" dialog box that pops up. Click on the “Null Value” option (see Figure 2), and finally click on the “OK” button to make all the blank lines in the table selected. Then right click on the selected area and select the “Delete → Entire Line” command in the shortcut menu that pops up.










Cico Tip: When using this method to delete, make sure that all the cells in other non-empty rows are filled with values, otherwise the records will be deleted accidentally. The phenomenon.
To delete empty lines in an Excel XP worksheet, the general method is to find out the blank lines and then delete them line by line, but this is very inconvenient. So how can you reduce the amount of work required to delete a hollow row of a worksheet? You can use the above method of operation.