How to Reduce Excel File Size with Pictures (2 Easy Ways)

You must compress the photos if you work with photographs in Excel. Otherwise, the Excel file size will rise. Here, you need to pay attention to the fact that while compressing, the image quality needs to be good. You must then compress those photos using the Excel built-in command after first reducing their size outside of Excel. In this article, we will show you how to Reduce Excel File Size with Pictures.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


2 Handy Approaches to Reduce Excel File Size with Pictures

As more data, formulae, and graphics are added to an Excel workbook, it has been known to become uncomfortably slow and weighty. Sometimes it’s simple to trim the fat and keep the size of the excel file under control, and other times it isn’t. The majority of us work and collaborate via emailing Excel files because Excel is not a web-based product. We will demonstrate to you how to reduce Excel file size with pictures by utilizing the Format Picture Tool and applying VBA Code in the following two methods.


1. Utilizing Picture Format Tool to Reduce Excel File Size with Pictures

In this first method, you will learn how to reduce Excel file size with pictures by utilizing the Review tab.

Step 1:

  • Firstly, go to the Insert tab.
  • Secondly, select the Illustrations command.
  • Thirdly, click on the Pictures option.
  • Finally, you can insert pictures using the Insert Picture Form option.

Sample Data

Step 2:

  • Now, navigate to the File Tab.

Sample Data

Step 3:

  • Here, click on the Save option first.
  • Then, select the Info option.
  • And you will see the actual file size of 124 KB.

Sample Data

Step 4:

  • In this step, click on the inserted picture first.
  • Then, open the Picture Format tool.
  • Besides, choose the Adjust command.

Sample Data

Step 5:

  • Here, the Compress Pictures windows will open.
  • From the compression, choose the Delete cropped areas of pictures option.
  • Now, click on the E-mail (96 ppi): minimize document size for sharing.
  • Finally, click on “OK” and save the workbook as well.

Sample Data

Step 6:

  • Now, Save the workbook first.
  • Then, select the Info option.
  • Finally, this is the outcome of the reduced Excel file size of 53.8 KB  with the pictures.

 Handy Approaches to Reduce Excel File Size with Pictures

Read More: Reduce Large Excel File Size by 40-60% (12 Proven Methods)


2. Applying VBA Code to Reduce Excel File Size

In this final session, we will create a VBA code to reduce the Excel file size with pictures using the Developer tab.

Step 1:

  • At first, we will use the Developer tab.
  • Then, we will select the Visual Basic command.

 Handy Approaches to Reduce Excel File Size with Pictures

Step 2:

  • Here, the Visual Basic window will open.
  • After that, from the Insert option, we will choose the new Module to write a VBA code.

 Handy Approaches to Reduce Excel File Size with Pictures

Step 3:

  • Now, paste the following VBA code into the Module
  • To run the program, click the “Run” button or press F5.
Sub Reduced_Picture_Size()
'Declaring variables
    Dim Mysheet As Worksheet
' Setting worksheet as VBA Code
    Set Mysheet = Worksheets("VBA Code")
    Mysheet.Activate
   Mysheet.Shapes(1).Select
' Compressed picture using commnad
    SendKeys "%e", True
    SendKeys "~", True
    Application.CommandBars.ExecuteMso "PicturesCompress"
End Sub

 Handy Approaches to Reduce Excel File Size with Pictures

VBA Code Breakdown

  • Firstly, we call our Sub Procedure as Reduced_Picture_Size().
  • Secondly, we declare our variables as Dim Mysheet as Worksheet.
  • Then, we set our worksheet name as VBA Code using Set Mysheet= Worksheets(“VBA Code”)
  • Finally, we will reduce our Excel file size with pictures as an  Application.CommandBars.ExecuteMso “PicturesCompress”.

Step 4:

  • This is the final result of the compressed Excel file containing the images.

 Handy Approaches to Reduce Excel File Size with Pictures

Read More: How to Reduce Excel File Size with Macro (11 Easy Ways)


Conclusion

In this article, I’ve covered 2 handy methods to reduce Excel file size with pictures. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo