How To Compress Picture Sizes In Excel


If you ever have inserted pictures into an Excel spreadsheet then this is one tips you will want to know. A picture can go a long way to enhance your Workbook, maybe it is a logo or informational visual. We will need to balance the value of the visual, with the increase in size of the file that will result from using a picture. Fortunately within Excel 2010 onwards and other Office products you can compress the size of your images to reduce the size of your workbook.

Here is how you do it-
  • Select the picture you want to compress
  • With the picture selected the contextual ribbon for picture tools will become active
  • Hit Compress Picture

70176402

 

The Compress Picture Dialog Box will appear- with a couple of compression options

i. Check Apply to this picture only if you want to restrict which pictures are compressed and how. Compression can affect the quality of the picture and you may want to use different compression rates for different pictures.
ii. Check Delete cropped areas of pictures once you completely finished cropping your pictures. Once done this cannot be undone.
You then have someTarget Output Options
Pixels Per Inch (ppi) determines the amount of detail retained in the original picture. After compression, the picture can look different, so before saving make sure the visual quality has not been compromised by the compression process. If you want to apply any artistic effect make sure you compress the picture first.Choose the option that matches the end result of your project. If you are printing then choose the print quality, emailing choose E-mail etc.
70177902
  • Click OK.
  • Compressing these pictures have the advantage of reducing the size for storage on servers or your computer as well as for sending via email.

Want To Watch The Video Tutorial?

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts