How to Compress Excel File to Smaller Size (7 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate the steps to how to compress an excel file to a smaller size. When you are dealing with lots of excel files, then it is very necessary to reduce the file size. Moreover, when you have to submit excel files to a certain website or send it to someone through an online site then it’s very important to have a smaller file size. After going through this article, you will learn how to compress an excel file to a smaller size on your own.


Download Practice Workbook

You can download the practice workbook from here.


7 Easy Methods to Compress Excel File to Smaller Size

Our aim is to compress an excel file to a smaller size. If you follow the methods correctly then you should learn how to compress excel files to a smaller size on your own.

1. Removing Irrelevant Worksheets/Data

In this case, our goal is to compress the excel file by removing irrelevant worksheets. To do that, we will follow the below steps.

Steps:

  • At first, we arranged our desired excel file.

Methods to Compress Excel File to Smaller Size

  • To reduce the file size, we will check how many worksheets it contains and whether every data sheet is necessary or not.

Methods to Compress Excel File to Smaller Size

  • Then, we will Right-click on the irrelevant worksheet and press Delete to remove it.

Methods to Compress Excel File to Smaller Size

  • Afterward, the relevant worksheets will remain like the below image.

Methods to Compress Excel File to Smaller Size

  • After saving the file, if you check the file size, you will get a reduced result.

Read More: How to Compress Excel File for Email (13 Quick Methods)


2. Transforming File into Binary Format (XLSB)

Now, we want to compress the excel file by transforming the file into Binary Format (XLSB) file. To fulfill this goal we have to follow the below steps.

Steps:

Methods to Compress Excel File to Smaller Size

  • Second, select the Save As option.

  • Third, choose the option Excel Binary Workbook(*.xlsb) and press OK.

Methods to Compress Excel File to Smaller Size

  • Lastly, you will get the xlsb file with reduced size.

Read More: How to Determine What Is Causing Large Excel File Size


3. Eliminating Irrelevant Formulas

We can also compress the excel file by eliminating irrelevant formulas. To do this follow the below steps.

Steps:

  • To begin with, select the entire worksheet and press the F5 button.
  • Then, the Go To dialog box will open on the screen.
  • Next, select the Special option and press OK.

Methods to Compress Excel File to Smaller Size

  • Then, the Go To Special window will open on the display.
  • Choose the Formulas option and click OK.

  • Last, you will get the reduced excel file.

Read More: How to Reduce Excel File Size with Macro (11 Easy Ways)


4. Compressing Images of File

Compressing images of the excel file can be another method to compress the excel file. The steps to do this are described below.

Steps:

  • Initially, if you have not uploaded the image yet and want to reduce its size before uploading then using TinyPNG is a very option. At first, select the image and drag it into the TinyPNG site to compress the image.

Methods to Compress Excel File to Smaller Size

  • But, if you have already added the excel file and compressed it without changing it, then you have selected the picture first.
  • Then, go to the Picture Format tab and select the Compress Pictures option.

Methods to Compress Excel File to Smaller Size

  • Next, the Compress Pictures window will open on the window.
  • Afterward, select the desired option and press OK.

  • Last, you will the reduced result like previous methods.

Read More: How to Reduce Excel File Size with Pictures (2 Easy Ways)


5. Using Compressed (zipped) Folder Option

Using the Compressed (zipped) folder option can be another method to compress the excel file. The steps are described below.

Steps:

  • In the beginning, select the excel file.
  • Second, Right-click on it.
  • Third, select the Send to option.
  • Fourth, choose the Compressed(zipped) folder option.
  • Last, you will get a reduced file similar to previous methods.

Read More: How to Compress Excel File to Zip (2 Suitable Ways)


6. Taking Off Data Formatting

For this instance, our goal is to compress the excel file by taking off data formatting. To do that, follow the below steps.

Steps:

  • First, go to the Home tab.
  • Second, choose the Editing option.
  • Third, select the Clear formats option from the Clear option.
  • Finally, you will get the desired result.


7. Removing Conditional Formatting

This method is similar to method 6 with a slight change. The steps of this method are.

Steps:

  • First, go to Home>Editing>Clear options.
  • If you have any condition formatting, select that and you will see the Clear option.
  • Last, you will get your desired result.

Things to Remember

  • Among all the methods using method 2 will reduce the maximum file size.
  • In the case of compressing images, it is recommended to reduce the file size before inserting it into the excel file.
  • Zipping the excel file gives a huge advantage if the excel files need to be sent to another device.

Conclusion

Henceforth, follow the above-described methods. Thus, you will be able to compress the excel files to a smaller size. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo