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
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.
- 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?
BANWARI says
PLEAE COULD U ADVISE ME HOW TO PUT (00123) IN A CELL
Barbara says
Hello
You can keep the leading zeros by creating a custom number format,
Home Tab – Number Group – click the dialog box launcher Button image next to Number – In the Category list, click Custom and then, in the Type box, type the number format, such as 00000 for a five-digit code
regards
Barbara