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.
- 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.
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.
- 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.
- Eventually, an Excel Binary Workbook named Compress Excel File is created and also the size is decreased from 24KB to 20 KB.
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.
- Secondly, go to Home > select Editing > choose Clear > click Clear All.
- Eventually, all the blank cells will be cleared.
Additionally, we can do this by following another way.
- Firstly, go to Home > select Editing > choose Find & Select > pick Go to Special.
- Eventually, a Go to Special window will appear.
- Secondly, select Blanks.
- Thirdly, click OK.
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.
- Secondly, choose Options.
- 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.
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.
- 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.
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.
- 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.
- Immediately, a PivotTable Options window will appear.
- Thirdly, select the following options shown in the picture below.
- Fourthly, click OK.
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.