How to Reduce Excel File Size by Deleting Blank Rows

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will demonstrate how to reduce Excel file size by deleting blank rows. Often a file in Excel becomes very large and takes a huge space in storage. In order to avoid this problem, we need to minimize the file size. The following article will help you reduce your Excel file size in different ways. We will use Microsoft 365 to do all these.

Reduce Excel File Size by Deleting Blank Rows Overview


Download Practice Workbook

You may download the following workbook to practice yourself.


4 Suitable Ways to Reduce Excel File Size by Deleting Blank Rows

In order to illustrate, we will use a sample dataset. For instance, the following dataset represents the customer names, their order details and the number of orders. There are some blank rows in the sheet which the operator wants to remove for his convenience.

Sample Dataset


Method 1: Deleting Blank Rows Manually to Reduce Excel File Size

When the worksheet is small, it is convenient to delete rows manually. Though it takes time to delete, this method gives a more accurate result.

Steps:

  • In the beginning, we press and hold the Ctrl key and choose the rows one by one.

Deleting Blank Rows Manually

 

  • Next, we select Delete in the ribbon command as well as Delete Sheet Rows.

Reduce Excel File Size Manually

  • After that, we get the result free of blank rows.

Result of Manual Deletion

Read More: How to Reduce Excel File Size Without Deleting Data (9 Tricks)


Method 2: Applying Find Command to Delete Blank Rows

It is very time-consuming to select and delete blank rows by inspection. A more convenient way is to use the Find command instead.

Steps:

  • Initially, we will select Find & Select and the Find from the ribbon command.

Deleting Blank Rows by Find Command to Reduce Excel File Size

 

  • Secondly, a dialog box appears in which we select the options like the following image.

Selecting Find All to Reduce File Size by Deleting Blank Rows

  • If we apply these, a new box will appear containing all the blank cells. We will select all of them by Ctrl+A.

Selecting the Blank Rows

  • In the end, we will close the dialog box and delete all the blank cells by clicking the Delete ribbon command and then Delete Sheet Rows.

 Result of Using Find Command to Reduce Excel File Size

Read More: Reduce Large Excel File Size by 40-60% (3 Proven Methods)


Similar Readings


Method 3: Reduce Excel File Size to Reduce Excel File Size by Filtering

The third method for deleting blank rows is to use the Filtering Function in the dataset. We will filter out the blanks and then delete those to remove blanks. We will follow the steps below.

Steps:

  • First, we select the whole dataset using Ctrl+A. Then we select Sort & Filter as well as Filter.

Deleting Blank Rows by Filtering

  • Later we select the dropdown menu of Serial No. and then Blanks.

Choosing Blanks Option for Filtering

  • By doing that we get all the blank rows in the dataset.

 Blank Rows From Filtering to Reduce Excel File Size

  • Finally, we delete blank cells and reduce the file size.

Result of Filtering after deleting Blank Rows

Read More: How to Compress Excel File More than 100MB (7 Useful Ways)


Method 4: Sorting Data to Delete Blank Rows

Another way to do the same operation as filtering is to apply the Sort command on the dataset. We will sort the data to find out the blanks and later we will delete those.

Steps:

  • In the beginning, we select all the data as before and choose the options like the image below.

Reduce Excel File Size by Sorting

 

 

  • By doing that, we get the sorted data where all the blank cells gather in the bottom of the dataset.

Initial Result of Sorting

  • After that we delete the blank cells like before and finally get the result.

 Final Result of Sorting

Read More: Why Is My Excel File So Large? (7 Reasons with Solutions)


Conclusion

We have discussed the ways to reduce Excel files by deleting blank rows in Excel in the above sections. Hope this will be very helpful for you. Let us know your views and recommendations in the comment section. Have a good day.


Related Articles

Junaed-Ar-Rahman

Junaed-Ar-Rahman

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed BSc in Biomedical Engineering from Bangladesh University of Engineering and Technology. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo