How to Compress Pictures in Excel. You can compress pictures in Microsoft Excel 2007 in just a few clicks with the "Compress Pictures" dialog box and reduce the file size of your workbook without compromising picture quality. Follow the steps below to compress pictures in Microsoft 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.
See related eHow articles to learn how to insert pictures into Microsoft Excel. If you want to select more than one picture to compress at the same time, hold down the "Shift" key on your keyboard while clicking to select all the pictures you want to be included.