How to Reduce Excel File Size Without Opening (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, the size of an Excel file can be significant if it contains a large amount of data. If your Excel file contains a large amount of data, it may function slower. There are several ways to reduce the size of an Excel file. Users need to reduce Excel files with larger data sets for better performance. In this article, we will show you how to reduce the size of an Excel file without opening it.

Excel users may need to reduce the size of their Excel files to increase functioning speed or while sharing the file. You can reduce the size of an Excel file in various ways. But, most of the ways need to open the Excel file first. In this article, you will see the step-by-step procedures of how to reduce the size of an Excel file without opening it. We will describe the whole procedure in four easy steps.

Step 1: Locating Excel File to Reduce its Size

In our first step, we will find the particular Excel file whose size we will reduce.

  • First of all, go to the specific folder where the Excel file is located.
  • Then, select the particular Excel file.

Step-by-Step Procedures to Reduce Excel File Size without Opening

Read More: How to Compress Excel File to Smaller Size


Step 2: Choosing Properties of Excel File

In the second step, we have some actions to perform.

  • First of all, right-click on the particular Excel file.
  • Then, you will find many options after right-clicking.
  • Select the Properties command.

Step-by-Step Procedures to Reduce Excel File Size without Opening


Step 3: Using the Advanced Option to Reduce Excel File Size Without Opening

After selecting the Properties command, we have to perform some more actions.

  • You will see the property box of the particular Excel file after selecting the previous command.
  • Then, click on the Advanced button in the dialogue box.

Step-by-Step Procedures to Reduce Excel File Size without Opening


Step 4: Compressing Contents of Excel File Without Opening

We will perform the last step of our whole procedure here.

  • After clicking the Advanced button, the Advanced Attributes dialogue box will pop up.
  • Mark the option named Compress contents to save disk space under the Compress or Encrypt attributes heading.
  • Then, press OK.

Sample Data Set

Lastly, we have completed the last step of our procedure.

  • We will check the particular Excel file after the above step.
  • We will see two blue arrows on the icon of the Excel file.
  • So, we have successfully finished the steps to compress our Excel file.

Sample Data Set

Read More: How to Reduce Excel File Size with Macro


Download Practice Workbook

You can download the free Excel workbook here and practice on your own.


Conclusion

That’s the end of this article. I hope you find this article helpful. By following the above steps, you will be able to reduce the size of an Excel file without opening it. Please share any further queries or recommendations with us in the comments section below. Our team is always concerned about your preferences.


Related Articles


<< Go Back to Excel Reduce File Size | Excel Files | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Araf Bin Jayed
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo