First, select the entire data range with headers, then go to the Data tab and select Filter as shown in the image.We can also use the filter option when we need to delete empty rows. Method 5: Delete Empty Rows at Bottom by Excel Filter Read More: How to Delete Row Using VBA (14 Ways) Yes, if you followed Method 1, you know how to do the rest work. From the dialogue box, we will select Special and then select Blanks option and click OK as shown in the image below.Īfter that, our data set will look kind of familiar.First, select the entire data range and press CTRL+G and a dialogue box will pop up.Go to Special is another cool option to delete empty rows. Method 4: Delete Empty Rows in Excel Using Go to Special

How to Delete Row Using Macro If Cell Contains 0 in Excel (4 Methods).Delete Rows in Excel with Specific Text (3 Methods).How to Delete Rows in Excel without Affecting Formulas (2 Quick Ways).Delete Rows Based on Another List in Excel (5 Methods).How to Delete Selected Rows with Excel VBA (A Step-by-Step Guideline).Read More: Delete Blank Rows in Excel (10 Handy Methods) At this point, we can simply right-click on mouse or press CTRL+- to delete entire rows at the bottom as we have already shown you in Method 1.Now, you can see, all the data are sorted leaving the empty cells at the bottom. First, select the entire data range you want to sort and go to the Data tab and select either Ascending or Descending sorting option as you please.Sorting is one of the easiest methods to delete empty rows at the bottom in Excel. Method 3: Delete Blank Rows at Bottom Using Sort Command Read More: How to Delete Hidden Rows in Excel (3 Methods) At this point, press CTRL+9 and it will hide all the rows at the bottom.

This will select all the cells at the bottom. Now, press CTRL+SHIFT+ Down Arrow + Right Arrow Key.First, select a cell at the bottom of your dataset.If we want to reduce our file size and keep our dashboard cleaner we can delete or hide all the unused blank rows at the bottom. Method 2: Delete Empty Rows at Bottom by Hiding Read More: How to Use VBA to Delete Empty Rows in Excel

You can see, all the blank rows are gone.

Now, right-click on the mouse or press CTRL+ –.

Press CTRL and select the entire blank rows.

If we have a small dataset then empty rows are easy to identify, we can do the job manually. Method 1: Excel Delete Empty Rows at Bottom Manually 7 Ways to Delete Empty Rows at Bottom in ExcelĪs you can see, our data set contains empty rows at the bottom, we will see 7 different methods including VBA to get rid of these empty rows.

Easy way to delete empty rows in excel