Microassist

Software Tips

Home » Software Tips » Six Easy Ways to Compress Excel Files

Six Easy Ways to Compress Excel Files

By   |    |    |  

Excel files containing images can quickly become large and unwieldy, making them difficult to share or upload. Fortunately, there are several simple ways to reduce the size of these files without compromising the quality of your work. In this post, we’ll explore six effective methods to compress Excel files with images, helping you manage your files more efficiently.

1. Compress Images Directly in Excel

One of the quickest ways to reduce the size of an Excel file with images is to compress the images directly within the program. Here’s how:

  1. Open your Excel file and click on any image.
  2. Navigate to the Format tab that appears once the image is selected.
  3. Click on Compress Pictures.
  4. In the dialog box, uncheck “Apply only to this picture” if you want to compress all images in the workbook.
  5. Choose your desired resolution under “Target output” (e.g., “E-mail (96 ppi)” for a smaller file size).
  6. Click OK to apply the changes.

Note: While this method can significantly reduce file size, be aware that it may also decrease image quality. For critical presentations or documents where image quality is paramount, you may want to use this option judiciously.

2. Reduce Image Resolution Before Inserting

Before adding images to your Excel file, consider reducing their resolution using an image editor like Photoshop, Paint, or an online tool. By saving the images in a compressed format such as JPEG, you can significantly decrease the size of your Excel file.

Tip: Aim for a balance between image quality and file size. For most purposes, a resolution of 96-150 PPI (pixels per inch) should suffice.

3. Convert to Excel Binary Workbook Format

Another method to reduce file size is to save your Excel file in a different format. The Excel Binary Workbook format (*.xlsb) often results in a smaller file size, especially for workbooks with a lot of data or images.

To save in this format:

  1. Go to File > Save As.
  2. Select Excel Binary Workbook (*.xlsb) from the file format dropdown.

Caution: While this format can significantly reduce file size, it may not be compatible with older versions of Excel or other spreadsheet programs. Ensure your intended recipients can open .xlsb files before using this method.

4. Remove Unused Data and Objects

If your Excel file contains unnecessary data, charts, or objects, removing them can help reduce the file size. Here are some items to consider removing:

  • Hidden sheets that are no longer needed
  • Unused columns or rows (especially those with formatting applied)
  • Commented-out formulas
  • Redundant charts or graphs
  • Excessive cell formatting in unused areas of the spreadsheet

To delete hidden sheets:

  1. Right-click on any sheet tab at the bottom of the Excel window.
  2. Select Unhide.
  3. Choose the hidden sheet you want to delete and click OK.
  4. Right-click on the newly unhidden sheet and select Delete.

5. Set Calculation Options to Manual

If your Excel workbook contains many complex calculations, it may be worth setting the calculation option to “Manual.” This can reduce file size, especially when dealing with large datasets.

To do this:

  1. Go to File > Options > Formulas.
  2. Under Calculation options, select Manual.

Important: Remember to manually recalculate your spreadsheet (press F9) after making changes when using this setting. Otherwise, you might be working with outdated values.

6. Remove Personal Information

Removing personal information and document properties can slightly reduce the file size and add an additional layer of security:

  1. Go to File > Info.
  2. Click on Check for Issues > Inspect Document.
  3. Select the information you’d like to remove.

This process removes metadata such as author names, comments, and revision history, which can take up space in larger files.

7. Use ZIP Compression for Sharing

While not a method to reduce the Excel file size itself, using ZIP compression can make the file smaller for sharing or storage purposes:

  1. Right-click on your Excel file in Windows Explorer.
  2. Select Send to > Compressed (zipped) folder.
  3. A new ZIP file will be created, which you can then share or store.

This method is particularly useful when you need to send multiple Excel files together.

By implementing these tips, you can significantly reduce the size of your Excel files without losing any important content. This not only makes your files easier to share but also helps improve their performance when working with them. Plus, removing personal information ensures your files are more secure.


Subscribe to Monthly Training Updates

Receive monthly productivity and training insights, software tips, and notices of upcoming classes!

Name

MENU