How to delete blank lines in Excel
In the case of small data, it can be done manually to delete, but for large data, this method will not be possible because it takes too much time.
1. Method 1
+ Step 1: Select all data to be deleted.
How to delete blank lines in Excel Picture 1
+ Step 2: Press the key combination Ctrl + G , a dialog box appears.
+ Step 3: Select the Speciel item as shown.
How to delete blank lines in Excel Picture 2
+ Step 4: Click Blanks
How to delete blank lines in Excel Picture 3
+ Step 5: Select Home Tab, click the Delete icon on the Toolbar.
How to delete blank lines in Excel Picture 4
After completing the above steps, the white lines will disappear.
2. Method 2
+ Step 1: Select all data, go to Data tab, select Filter.
How to delete blank lines in Excel Picture 5
+ Step 2: Deselect Select All and drag the slider to the bottom.
+ Step 3: Check Blanks and select OK.All blank lines will be filtered.
How to delete blank lines in Excel Picture 6
+ Step 4: Go to Home, select the Deleta icon on the Toolbar.
How to delete blank lines in Excel Picture 7
Or Right-click to delete.
How to delete blank lines in Excel Picture 8
You should read it
- Instructions for deleting empty lines and columns in Excel 2016
- 8 How to delete blank rows in ExcelHow to delete blank rows in Excel
- How to delete white pages in Excel
- Instructions for adding alternate blank lines on Microsoft Excel
- MS Excel - Lesson 4: Working with lines, columns, sheets
- Instructions to delete blank lines (blank lines) in Excel
- 3 ways down the line in Excel, line break, down row in 1 Excel cell
- Line breaks in Excel
- How to fix the error is not down the line in Excel
- Some tricks or LINE users should know
- How to delete LINE account?
- How to disable Hyperlink in Excel
May be interested
Instructions on how to split and merge cells in Word
Page numbering in Excel does not start with number 1
2 ways to create horizontal lines extremely fast in WORD
10 functions of Paste in Excel you need to know
Adjust the spacing between columns in Word
Instructions on how to use the ROUND function in excel