Value = WorksheetFunction.Transpose(arr)Ī Key1:=Cells(, + column_num) With Cells(, + column_num).Resize(row_num, 1) Sub remove_empty_lines()ĭim start_time, arr(), rng, row_num As Long, column_num As Long, i, j
Select the range you want to remove blank rows, click Home tab, then in Editing group, click Find & Select > Go To Special. Navigate to the Home tab, click Sort and Filter and then select Filter.Įach column header will display an arrow button. Now please do as below steps to remove empty rows with Go To Special rows: 1. Highlight just the range of data containing the blank cells. Method 3: Delete Blank Rows Using Excel Filter
This tutorial will show you 4 simple methods to quickly delete or remove blank rows from your Excel spreadsheet in Excel 2016 / 2013 / 2010 / 2007.
Got a large Excel spreadsheet that is full of empty rows? How to quickly remove all the blank rows that are scattered everywhere in your Excel worksheet? Deleting each blank row manually can be very annoying and time-consuming.