How to Reduce Size of Excel Files

Step-by-Step Guide

1. 1

   Step 1: Open a Microsoft Excel file.

   Do so by double-clicking on the green and white app with an X, then clicking on File and Open..., and selecting the file. ,,,,, Files saved in this format are considerably smaller than standard .xls files., The smaller Excel file will be saved on your computer., Do so by double-clicking on the green and white app with an X, then clicking on File and Open..., and selecting the file., To do so, click on the first empty row number, then press and hold Ctrl+⇧ Shift+↓ (Windows) or ⌘+⇧ Shift+↓ (Mac).
   
   The arrow keys are in the lower-right corner of most keyboards. ,,, This clears unnecessary formatting from cells that are not being used., To do so, click on the first empty column letter, then press and hold Ctrl+⇧ Shift+→ (Windows) or ⌘+⇧ Shift+→ (Mac).
   
   The arrow keys are in the lower-right corner of most keyboards. ,,, This clears unnecessary formatting from cells that are not being used., Do so by double-clicking on the green and white app with an X, then clicking on File and Open..., and selecting the file.,, It's in the "Styles" part of the ribbon.,,, Do so by double-clicking on the green and white app with an X, then clicking on File and Open..., and selecting the file.,, It's in the "Editing" part of the ribbon.,,,,, It's the eraser icon.,, Do so by double-clicking on the green and white app with an X, then clicking on File and Open..., and selecting the file., It's in the menu bar at the top of the screen.,,,,,,,,, Do so by double-clicking on the green and white app with an X, then clicking on File and Open..., and selecting the file., To do so:
   In Windows, click on an image, then click on the Format, tab and click on Compress in the toolbar.
   
   On Mac, click on File and then Reduce File Size…. , ,, ,, The images in the file have been compressed and extraneous image data has been deleted.
2. 2

   Step 2: Click File.

3. 3

   Step 3: Click Save As….

4. 4

   Step 4: Type a file name.

5. 5

   Step 5: Click the "File Format:" drop-down.

6. 6

   Step 6: Click Excel Binary Workbook under "Specialty Formats."

7. 7

   Step 7: Click Save.

8. 8

   Step 8: Open a Microsoft Excel file.

9. 9

   Step 9: Select all empty rows.

10. 10

    Step 10: Click on the Home tab (Windows) or Edit in the menu bar (Mac).

11. 11

    Step 11: Click Clear.

12. 12

    Step 12: Click Clear All (Windows) or Format (Mac).

13. 13

    Step 13: Select all empty columns.

14. 14

    Step 14: Click the Home tab (Windows) or Edit in the menu bar (Mac).

15. 15

    Step 15: Click Clear.

16. 16

    Step 16: Click Clear All (Windows) or Format (Mac).

17. 17

    Step 17: Open a Microsoft Excel file.

18. 18

    Step 18: Click the Home tab at the top of the screen.

19. 19

    Step 19: Click Conditional Formatting.

20. 20

    Step 20: Click Clear Rules.

21. 21

    Step 21: Click Clear Rules from Entire Sheet.

22. 22

    Step 22: Open a Microsoft Excel file.

23. 23

    Step 23: Click the Home tab at the top of the screen.

24. 24

    Step 24: Click Find & Select.

25. 25

    Step 25: Click Go To….

26. 26

    Step 26: Click Special….

27. 27

    Step 27: Click the Blanks radio button.

28. 28

    Step 28: Click OK. All the empty cells in the data set will be highlighted.

29. 29

    Step 29: Click Clear.

30. 30

    Step 30: Click Clear All.

31. 31

    Step 31: Open a Microsoft Excel file.

32. 32

    Step 32: Click Edit.

33. 33

    Step 33: Click Find.

34. 34

    Step 34: Click Go To….

35. 35

    Step 35: Click Special….

36. 36

    Step 36: Click the Blanks radio button.

37. 37

    Step 37: Click OK. All the empty cells in the data set will be highlighted.

38. 38

    Step 38: Click Edit in the menu bar.

39. 39

    Step 39: Click Clear.

40. 40

    Step 40: Click Format.

41. 41

    Step 41: Open a Microsoft Excel file.

42. 42

    Step 42: Open the Compression dialog box.

43. 43

    Step 43: Click the drop-down menu next to "Picture Quality."

44. 44

    Step 44: Select a lower image resolution.

45. 45

    Step 45: Check "Delete cropped areas of pictures."

46. 46

    Step 46: Click All pictures in this file.

47. 47

    Step 47: Click OK.

Detailed Guide

About the Author