Using the method to delete the blank lines in the Excel table makes the table more refreshing

When we use Excel to count and analyze objects, data entry can not be done overnight, record addition, deletion, cutting Mergers are indispensable. After many edits and revisions, there are often many blank lines in the form. 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, which allows you to easily delete empty lines in an Excel spreadsheet.

Figure 1 Excel data table

First, the positioning delete method

Use the "positioning" function provided in Excel, once Sexually locate all the blank lines in the table, and then "snap them all".

Select the “Edit →Location" menu command, and click the “Targeting" button in the "Location" dialog box that appears, followed by the "Targeting Conditions" In the dialog box, click the “Null Value” option (see Figure 2), and finally click the “OK” button to select all the blank lines in the table. Then right click on the selected area and select the “Delete → Entire Line” command in the shortcut menu that pops up.

Figure 2 “Targeting Conditions&Dialogs

Cico Tip: Use this method to ensure that all cells in other non-empty rows are removed when using this method The values ​​are filled in, otherwise the phenomenon of accidental deletion of records will occur.

To delete empty lines in an Excel XP worksheet, the general method is to find out the blank lines and 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.