Buzz
If you often work in the Excel environment, dealing with the frustration of waiting for large files to open can be quite bothersome. This article guides you on how to reduce the file size in Excel.
To trim down the file size, you need to identify the factors causing its bulkiness. If you can't pinpoint the issue, you can reduce the file size by following these steps:
1. Save the file as a binary file
2. Eliminate Blank Formatting in Rows and Columns
HomeEditingClearClear All
3. Eliminate Conditional Formatting
Sometimes your file contains conditional formatting, a culprit behind bulky data files. To fix this, remove conditional formatting. Go to the Home tab -> Conditional Formatting -> Clear Rules -> Clear Rules from entire Sheet:
4. Compress Images within Excel File
Your data file contains numerous images, typically with substantial file sizes. Therefore, to use images efficiently in your data file, compress them to reduce file size.
Select the image file -> go to the Format tab -> Compress Pictures to compress the images:
In the dialog box, check the Apply only to this picture and Delete cropped areas of pictures options (to remove cropped areas) -> click OK to compress the images:
Above are some methods to help you reduce the Excel file size. Wishing you success!
