How You Can Reduce Excel File Size Without Deleting Data? Office.com/setup
Sometimes, a large-sized Excel workbook creates lots of problems like the file will respond very slow, it will take more time to save any changes, and it take time to upload etc. So in this blog, you will read how to reduce Excel File Size without deleting data. For assistance, you can visit to the official website of MS Office via www.office.com/setup.
Method To Reduce Excel File Size Without Deleting Data: office.com/setup
1. Remove Cell Formatting:
First, you should select the range over which you want to clear the formatting. Then, you should go to the Home Tab and then click on Editing Group and then choose Clear and then select Clear Formats option.
2. Reduce The Size Of The Image File Added In MS Excel:
For this, you should open your excel file which contains an image or logo and then just choose the pictures for compressing. Now, you should go to the Picture Tools and then click on Format tab, and then in the Adjust group how to reduce Excel file size you should hit on the Compress Pictures. If in case, you only see the Adjust group then you will see the Compress Pictures button appears without a label. If you want to decrease the size of a specific image and then you should leave all other images present in the document, and then mark the Apply only to this picture check box. If in case, you unmark the Apply only to this picture checkbox then this will override any previous modifications which you have done for other images. After this, you should go to the Resolution and then just select the resolution which you want and then click on OK button .
3. Convert File type to Binary Format (XLSB):
For this, you should click on the File tab and then you should go to the Save As option. Now, you should click on the Browse button just to change the file type. Here from the Save As dialog box, you should pick the Excel Binary Workbook (.xlsb) file type. And then click on Save option.
4. Remove Unnecessary Formulas:
You should open the Excel file and then press the ctrl + A keys just to select the entire worksheet/dataset and then just press the F5 key. Now, you should open the Go To option and then click on the ‘Special’. After this, you should select the Formulas and then just click on OK button. Here, you have selected all the cells which have a formula. Then, you should press the ctrl + C key to copy the selected cells. Now, you should click on the Home tab and then from the Clipboard group, you should click on the Paste option. After this, you should click on the Paste Value icon.
5. Compress The File (ZIP IT):
First, you should right-click on the Excel File which you want to zip. Now, you should take your mouse cursor to the Send to option and then just click on the ‘Compressed (zipped) folder’ option.
The above method will help you to reduce the Excel File Size Without Deleting Data. But if the customer need any kind of support then just contact to the customer care of MS Office via www.office.com/setup.