How to Compress Pictures in Excel
-
Open Microsoft Excel 2007 and start a new workbook and insert at least one picture into it, or open an existing workbook from your files that contains at least one picture you would like to compress.
-
Click to select the picture that you want to compress. After you have clicked the picture it will be surrounded by white sizing handles indicating that it is selected.
-
Choose the "Format" tab at the top of the screen to display the Format ribbon. The Format ribbon contains all the commands you can use to format a picture in Excel.
-
Select the "Compress Pictures" button in the "Adjust" section of the Format ribbon. The "Compress Pictures" dialog box will open.
-
Click to add a checkmark so you compress only the selected pictures and click the "Options" button in the "Compress Pictures" dialog box. The "Compression Settings" dialog box will open.
-
Choose your compression options and target output for the selected picture in the "Compression Settings" dialog box. You can choose for the compression to occur on saved and for any cropped areas of the picture to be deleted. You can also choose to for the picture to compress depending on whether you intend to print it, view it in Excel or email it. Click the "OK" button after you have made your selections to close the dialog box.
-
Click "OK" to close the "Compress Pictures" dialog box and compress the selected picture.