Content

• Steps

WikiHow today teaches you how to reduce your Microsoft Excel file storage by removing some formats, compressing images or saving files in a lighter format.

Steps

Part 1 of 6: Save file as binary file

1. 

   Open up the Microsoft Excel file. Double click on the white Exel application with text X green, then you click the button File, click on the option Open ... (open) then select the file to operate.

2. 

   
   
   To save the new file, click File.

3. 

   Choose Save As ... (save as…).

4. 

   
   
   Next, type a new file name in the dialog box.

5. 

   
   
   Then, click the drop-down menu located under the item "File Format" (file format).

6. 

   
   
   Choose the format Excel Binary Workbook (binary file) is below the category "Specialty Formats.’ The file saved in this format is much smaller than the standard file with .xls extension.

7. 

   
   
   Finally, click the button Save. The smaller Exel file will be saved to the computer. advertisement

Part 2 of 6: Remove formatting from blank rows and columns

1. 

   Open up the Microsoft Excel file. Double click on the white Exel application with text X green, then you click the button File, click on the option Open ... then select the file to manipulate.

2. 

   
   
   Select all empty rows. Click on the number for the first empty row, then press and hold the key combination Ctrl+⇧ Shift+↓ (Windows) good ⌘+⇧ Shift+↓ (Mac).
   • The navigation key is usually located in the lower right corner for most keyboards.

3. 

   Click on the tab Home (Windows) or tab Edit (Mac) is in the menu bar.

4. 

   Click the button Clear (erase).

5. 

   To finish, you choose Clear All (delete all) for good Windows operating system Format (format) for the Mac operating system. This will remove the unnecessary formatting from the cells you don't use.

6. 

   Select all empty columns. Click on the letter that specifies the first empty row, then press and hold the key combination Ctrl+⇧ Shift+→ (Windows) or ⌘+⇧ Shift+→ (Mac).
   • The navigation key is usually located in the lower right corner for most keyboards.

7. 

   Click on the tab Home (Windows) or tab Edit (Mac) is in the menu bar.

8. 

   Click the button Clear (erase).

9. 

   Finally, click Clear All (Windows) good Format (Mac). This will remove the unnecessary formatting from the cells you don't use. advertisement

Part 3 of 6: Removing conditional formatting

1. 

   Open up the Microsoft Excel file. Double click on the white Exel application with text X green, then you click the button File, click on the option Open ... then select the file to manipulate.

2. 

   Click the tab Home located above the screen.

3. 

   Click the button Conditional Formatting (conditional formatting) is in the "Styles" (template) section on the panel.

4. 

   Select next option Clear Rules (delete rules).

5. 

   Finally, click Clear Rules from Entire Sheet (delete rules in all sheets). advertisement

Part 4 of 6: Removing formatting from blank cells on Windows

1. 

   Open up the Microsoft Excel file. Double click on the white Exel application with text X green, then you click the button File, click on the option Open ... then select the file to manipulate.

2. 

   Click the tab Home located above the screen.

3. 

   Click on the button Find & Select (find and select) in the "Editing" section of the navigation bar.

4. 

   Click on options Go To ... (go…).

5. 

   Click Next Special ... (especially…)

6. 

   Click the button Blanks (empty cells).

7. 

   
   
   Choose OK. Then, all blank cells in the data will be highlighted.

8. 

   Then you click the button Clear have an eraser shape.

9. 

   
   
   Finally, click Clear All to complete. advertisement

Part 5 of 6: Remove formatting from blank cells on Mac

1. 

   Open up the Microsoft Excel file. Double click on the white Exel application with text X green, then you click the button File, click on the option Open ... then select the file to manipulate.

2. 

   
   
   Click on the tab Edit located above the screen.

3. 

   Choose an option Find (search)

4. 

   Click Next Go To ....

5. 

   Next, click Special ....

6. 

   
   
   Click the button Blanks.

7. 

   Then you click OK. All blank cells in the data will be highlighted.

8. 

   
   
   Continue, click on the section Edit in the menu bar.

9. 

   Click the button Clear.

10. 

    
    
    Finally, click Format to complete. advertisement

Part 6 of 6: Compressing images

1. 

   Open up the Microsoft Excel file. Double click on the white Exel application with text X green, then you click the button File, click on the option Open ... then select the file to manipulate.

2. 

   Open the Compression dialog box (compress data) by:
   • On Windows operating systems, click the image in the current Exel file, then, click the tab Format then choose an option Compress (compressed) in the toolbar.
   • On Mac, click File then choose Reduce File Size… (reduce file size).

3. 

   Then, click on the drop-down menu next to "Picture Quality’ (image quality).

4. 

   
   
   Please choose a lower image resolution.

5. 

   Don't forget to check the box "Delete cropped areas of pictures" (delete cropped image areas).

6. 

   
   
   Continue, click All pictures in this file (all images in the current file).

7. 

   Finally, click OK. The necessary images in the file will be compressed, and unrelated images will be deleted. advertisement