How to Compress Pictures in Excel

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.

Step

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.

Step

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.

Step

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.

Step

Select the "Compress Pictures" button in the "Adjust" section of the Format ribbon. The "Compress Pictures" dialog box will open.

Step

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.

Step

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.

Step

Click "OK" to close the "Compress Pictures" dialog box and compress the selected picture.