How to Reduce Excel File Size
Save the file as a binary file
How to Reduce Excel File Size Picture 1
Open the Microsoft Excel file. Double click on the white Excel application with the green X , then click the File button, click on the Open. option and select the file you want to work with.
How to Reduce Excel File Size Picture 2
To save a new file, click File .
How to Reduce Excel File Size Picture 3
Select Save As… (save as…).
How to Reduce Excel File Size Picture 4
Continue, type the new file name into the dialog box.
How to Reduce Excel File Size Picture 5
Then, click the drop-down menu located under "File Format" .
How to Reduce Excel File Size Picture 6
Select the Excel Binary Workbook format under "Specialty Formats." Files saved in this format are much smaller than files with the standard .xls extension.
How to Reduce Excel File Size Picture 7
Finally, click the Save button . The smaller Excel file will be saved to the computer.
Remove formatting from blank rows and columns
How to Reduce Excel File Size Picture 8
Open the Microsoft Excel file. Double click on the white Excel application with the green X , then click the File button, click on the Open. option and then select the file you want to work with.
How to Reduce Excel File Size Picture 9
Select all empty rows. Click on the number of the first empty row, then press and hold the key combination Ctrl+ ⇧ Shift+ ↓(Windows) or ⌘+ ⇧ Shift+ ↓(Mac).
Navigation keys are usually located in the lower right corner on most keyboards.
How to Reduce Excel File Size Picture 10
Next, click on the Home tab (Windows) or Edit tab (Mac) located in the menu bar.
How to Reduce Excel File Size Picture 11
Click the Clear button .
How to Reduce Excel File Size Picture 12
To finish, select Clear All for Windows operating systems or Format for Mac operating systems. This will remove unnecessary formatting from unused cells.
How to Reduce Excel File Size Picture 13
Select all empty columns. Click on the letter that defines the first empty row, then press and hold the key combination Ctrl+ ⇧ Shift+ →(Windows) or ⌘+ ⇧ Shift+ →(Mac).
Navigation keys are usually located in the lower right corner on most keyboards.
How to Reduce Excel File Size Picture 14
Continue, click on the Home tab (Windows) or Edit tab (Mac) located in the menu bar.
How to Reduce Excel File Size Picture 15
Click the Clear button .
How to Reduce Excel File Size Picture 16
Finally, click Clear All (Windows) or Format (Mac). This will remove unnecessary formatting from unused cells.
Remove conditional formatting
How to Reduce Excel File Size Picture 17
Open the Microsoft Excel file. Double click on the white Excel application with the green X , then click the File button, click on the Open. option and then select the file you want to work with.
How to Reduce Excel File Size Picture 18
Click the Home tab located at the top of the screen.
How to Reduce Excel File Size Picture 19
Next click the Conditional Formatting button located in the "Styles" section of the control panel.
How to Reduce Excel File Size Picture 20
Select the Clear Rules option (delete the rules).
How to Reduce Excel File Size Picture 21
Finally, click Clear Rules from Entire Sheet (delete rules in all sheets).
Remove formatting from blank cells on Windows
How to Reduce Excel File Size Picture 22
Open the Microsoft Excel file. Double click on the white Excel application with the green X , then click the File button, click on the Open. option and then select the file you want to work with.
How to Reduce Excel File Size Picture 23
Click the Home tab located at the top of the screen.
How to Reduce Excel File Size Picture 24
Continue, click the Find & Select button located in the "Editing" section on the control bar.
How to Reduce Excel File Size Picture 25
Click on the Go To… option (go to…).
How to Reduce Excel File Size Picture 26
Click on Special… (special…)
How to Reduce Excel File Size Picture 27
Click the Blanks button (blank cells).
How to Reduce Excel File Size Picture 28
Select OK . Then, all blank cells in the data will be highlighted.
How to Reduce Excel File Size Picture 29
Then, click the Clear button shaped like an eraser.
How to Reduce Excel File Size Picture 30
Finally, click Clear All to finish.
Remove formatting from blank cells on Mac
How to Reduce Excel File Size Picture 31
Open the Microsoft Excel file. Double click on the white Excel application with the green X , then click the File button, click on the Open. option and then select the file you want to work with.
How to Reduce Excel File Size Picture 32
Click on the Edit tab located at the top of the screen.
How to Reduce Excel File Size Picture 33
Select the Find option (search)
How to Reduce Excel File Size Picture 34
Click on Go To… .
How to Reduce Excel File Size Picture 35
Next, click on Special… .
How to Reduce Excel File Size Picture 36
Click the Blanks button .
How to Reduce Excel File Size Picture 37
Then you click OK . All blank cells in the data will be highlighted.
How to Reduce Excel File Size Picture 38
Continue, click on Edit in the menu bar.
How to Reduce Excel File Size Picture 39
Click the Clear button .
How to Reduce Excel File Size Picture 40
Finally, click Format to complete.
Compress images
How to Reduce Excel File Size Picture 41
Open the Microsoft Excel file. Double click on the white Excel application with the green X , then click the File button, click on the Open. option and then select the file you want to work with.
How to Reduce Excel File Size Picture 42
Open the Compression dialog box by:
On Windows, click on the image in the current Excel file, then click the Format tab and select the Compress option in the toolbar.
On the Mac operating system, click File then select Reduce File Size. (reduce file size).
How to Reduce Excel File Size Picture 43
Then, click the drop-down menu next to "Picture Quality " .
How to Reduce Excel File Size Picture 44
Please choose a lower image resolution.
How to Reduce Excel File Size Picture 45
Don't forget to check the "Delete cropped areas of pictures" box .
How to Reduce Excel File Size Picture 46
Continue, click on All pictures in this file (all images in the current file).
How to Reduce Excel File Size Picture 47
Finally, click OK . Necessary images in the file will be compressed, and irrelevant images will be deleted.
You should read it
- How to reduce the size of Excel files
- Top 3 best software to reduce Excel file size 2020
- How to reduce the size of JPG files in Windows 10
- How to Reduce Size of Excel Files
- How to Reduce PDF File Size
- Tips to reduce the size of PowerPoint files should be known
- How to reduce PDF file size by software
- How to reduce the size and size of Word document files containing images
- How to reduce the file size Cad
- How to reduce video file size with FFMPEG from Linux Terminal
- How to compress PDF files on macOS does not reduce quality
- How to reduce PDF file size online