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

If you are looking for how to compress an Excel file more than 100MB, then you are in the right place. In our practical life, we often need to use Excel files and transfer this file to various devices and need to share it. The file size is an important factor there. So, we often need to compress it. In this article, we’ll try to discuss how to compress Excel file more than 100MB.


Download Practice Workbook


7 Ways to Compress Excel File More than 100MB

There are various ways to compress an Excel file or to reduce the size of it. Let’s discuss the methods to compress Excel files.


1. Compress Excel File More than 100 MB to ZIP/RAR

We can compress Excel files to ZIP/RAR and thus reduce the size of it.

  • Firstly, right-click on our Excel file named Compress Excel File.
  • Secondly, choose to Add to Archive.

compress excel file more than 100mb

  • Consequently, an Archive Name and Parameters window will appear.
  • Thirdly, go to General > select RAR or ZIP in the Active Format We have selected RAR.
  • Fourthly, click OK.

compress excel file more than 100mb, ZIP/RAR

So, now our Excel file is compressed to a RAR file.

Disclaimer: We used WinRAR software as an example. No business issue or advertisement is involved.

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


2. Using Excel Binary Format for Saving Excel File to Compress Excel File More than 100 MB

Saving the workbook as a Binary file in the format .xlsb can save a great amount of space by reducing the file size by almost up to 60%. This is one of the simplest methods to reduce the Excel file size i.e. to compress it.

  • Firstly, go to File.

compress excel file more than 100mb, binary format

  • Secondly, select Save As > click on the icon of file option > choose file type as Excel Binary Workbook (*.xlsb) > click Browse and keep the file in the specified place of the device.

compress excel file more than 100mb, binary format

  • Eventually, an Excel Binary Workbook named Compress Excel File is created and also the size is decreased from 24KB to 20 KB.

compress excel file more than 100mb, binary format

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


3. Clearing Blank Cells to Reduce Excel File Size

Blank cells occupy spaces in an Excel file. If we clear the blank cells then the size of the file is reduced at a large amount.

  • To clear blank cells, firstly, click CTRL + SHIFT + + →. The arrow signs indicate where we need to put our command.

compress excel file more than 100mb, clearing blank cells

  • Secondly, go to Home > select Editing > choose Clear > click Clear All.
  • Eventually, all the blank cells will be cleared.

compress excel file more than 100mb, clearing blank cells

 

Additionally, we can do this by following another way.

  • Firstly, go to Home > select Editing > choose Find & Select > pick Go to Special.

compress excel file more than 100mb, clearing blank cells

  • Eventually, a Go to Special window will appear.
  • Secondly, select Blanks.
  • Thirdly, click OK.

compress excel file more than 100mb, clearing blank cells

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


4. Reducing the Number of Worksheets to Compress Excel File More than 100 MB

If we have any worksheets with data that we are not using or any formula in those worksheets which are not of any use, then just delete the worksheets. Additional worksheets just make the size of the Excel file bigger and deleting those unnecessary worksheets reduces the size a lot.

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


5. Saving Pictures at Lower Resolution

Sometimes, we have pictures in our Excel file which actually takes up a handsome space and thus increases the file size. We can solve this issue by saving those pictures at a lower resolution.

  • To do this, firstly, go to File.

compress excel file more than 100mb, saving pictures at lower resolution

  • Secondly, choose Options.

compress excel file more than 100mb, saving pictures at lower resolution

 

  • An Excel Options window will appear.
  • Thirdly, go to Advanced.
  • Fourthly, select Discard Editing Data in the Image Size and Quality Make sure that Do not Compress Images in file is unselected
  • Fifthly, in the Default Resolution option choose 150 ppi or lower. In most cases, we don’t need the resolution to be higher than that.

compress excel file more than 100mb, saving pictures at lower resolution

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


6. Compressing Pictures

We can compress the pictures in an Excel file and it will also reduce the size of the file a lot.

  • Firstly, click on the picture > go to Picture Format > select Compress Pictures.

compressing pictures

  • Eventually, a Compress Pictures window will appear.
  • Secondly, in the Compression options, select Delete cropped areas of pictures. If we need to compress only the selected picture then select Apply only to this picture. But if we need to compress all the pictures in the file just deselect this option.
  • Thirdly, in the Resolution box select Use default resolution.
  • Fourthly, click OK.

compressing pictures

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


7. Not Saving the Pivot Cache with the File

If our spreadsheet contains PivotTable, we can reduce the file size by not saving the PivotTable source data cache with the file. Suppose, we have the following PivotTable in our spreadsheet.

not saving pivot cache

  • To reduce file size by not saving Pivot cache with the file, firstly, select any cell in the PivotTable.
  • Secondly, go to PivotTable Analyze > select PivotTable > choose Options.

not saving pivot cache

  • Immediately, a PivotTable Options window will appear.
  • Thirdly, select the following options shown in the picture below.
  • Fourthly, click OK.

not saving pivot cache

Read More: How to Reduce Excel File Size with Pivot Table


Conclusion

We can compress or reduce Excel file size efficiently if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.


Related Articles

Towhid

Towhid

Name: MD SHAJRATUL ALAM TOWHID Date of Birth: 6th September 1996 Religion: Islam Nationality: Bangladeshi

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo