If you are looking for how to compress an Excel file of more than 100 MB, then you are in the right place. In our practical life, we often need to use Excel files and transfer these files to various devices and need to share them. 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 files of more than 100MB.
How to Compress Excel File More than 100MB: 7 Useful Ways
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.
- Right-click on our Excel file named Compress Excel File.
- Choose to Add to archive.
- An Archive name and parameters window will appear.
- Go to General > Select RAR or ZIP in the Active format. We have selected RAR.
- Finally, 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 Smaller Size
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.
- Go to File.
- Select Save As > Choose file type as Excel Binary Workbook (*.xlsb) > Click Browse and keep the file in the specified place on the device.
- Excel Binary Workbook named Compress Excel File is created and the size is decreased from 24KB to 20 KB.
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 by a large amount.
- To clear blank cells, click CTRL + SHIFT + ↓ + →. The arrow signs indicate where we need to put our command.
- Go to Home > Select Editing > Choose Clear > Click Clear All.
- All the blank cells will be cleared.
Additionally, we can do this by following another way.
- Go to Home > Select Editing > Choose Find & Select > Pick Go to Special.
- The Go to Special window will appear.
- Select Blanks and click OK.
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 that 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 Compress Excel File for Email
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.
- Go to File.
- Choose Options.
- An Excel Options window will appear.
- Go to Advanced.
- Check Discard Editing Data in the Image Size and Quality. Make sure that Do not Compress Images in file is unchecked.
- In the Default Resolution option, choose 150 ppi or lower. In most cases, we don’t need the resolution to be higher than that.
6. Compressing Pictures
We can compress the pictures in an Excel file and it will also reduce the size of the file a lot.
- Click on the picture > Go to Picture Format > Select Compress Pictures.
- The Compress Pictures window will appear.
- In the Compression options, mark 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.
- In the Resolution box, select Use default resolution and click OK.
Read More: How to Reduce Excel File Size with Pictures
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.
- Select any cell in the PivotTable to reduce the file size by not saving the Pivot cache with the file.
- Go to PivotTable Analyze > Select PivotTable > Choose Options.
- The PivotTable Options window will appear.
- Select the following options shown in the picture below and click OK.
Download Practice Workbook
We can compress or reduce Excel file size efficiently if we study this article properly. Please feel free to visit our website for further queries.