. Next, Click the “Options” button, and select “Values” from the “Look in” dropdown. Let the “Find What” textbox remain blank and click “Find All”. After this the “Find and Replace” dialog will display all the blank cells. Click any one record and press Ctrl + A to select all the blank cells.
Now, Close the “Find and Replace” dialog and without clicking anywhere else navigate to ‘Home’ ‘Delete’ ‘Delete Rows’. This will delete all the selected rows.
Excel - A Macro to copy and paste data in next blank cell - How-To - Excel Excel/VBA - Get the row number of the first blank cell - How-To - Excel Published by aakai1056. Apr 19, 2017 - The first thing you need to tell Excel is which areas of the spreadsheet it should include when searching for blank rows. To do this select a data.
![Excel Excel](/uploads/1/2/5/4/125414136/298117081.gif)
Method 3: Eliminate Blanks by Using Excel Filter Functionality: In this method we are going to use Excel’s Auto filter functionality to delete the blank rows. Follow the below steps to use this method:. First of all select the range from which you need to remove the unfilled rows. Navigate to “Home” “Sort and Filter” “Filter” or alternatively you can also press the Shift + Ctrl + L keys to apply a filter. After this select a column, click the filter dropdown, uncheck all the values excepting “Blanks” and click “Ok”. Now, with all the unfilled rows selected, navigate to ‘Home’ ‘Delete’ ‘Delete Rows’. Finally remove the filter and you will see unfilled rows eliminated.
Method 4: Remove Blank Rows by using a macro: If you want to eradicate empty rows using a macro then you can use the following code. This code internally uses the same mechanism that we did in Method 1.