2. When checking the contents of Excel, it is found that the data size is 6.28mb. If the transmission limit is 2MB, it cannot be sent.
3. At this time, we can select a picture, and the "Format" option will appear in the Excel toolbar. Select one of the Compressed Pictures. When you only need to compress this selected picture, please check "Only for selected photos" to compress the picture.
4. After compression, check the file size and find that it has become 742KB. This completes the image compression.
How to compress pictures and reduce file size in EXCEL tables? How to compress pictures and reduce file size in EXCEL tables? Let me teach you.
First, we open an excel document with pictures, and then click Format in the toolbar.
The interface pops up, and we click on the compressed file;
The pop-up interface, we click OK, so we can compress the picture;
Finally, we click the file, and then we can click Save, and the size of the file will become smaller.
The method and step diagram of image compression in excel. Entering too much data in Excel will inevitably cause the document size to be too large. At this time, it is necessary to compress the data in Excel. So how to compress the pictures in Excel? Next, I will bring you the method of image compression in excel for your reference.
Image compression method in excel 1
Insert a high-definition big picture in Excel first, as shown below:
Then save the Excel file, and then close the Excel file. Now let's look at the size of this Excel file. Right-click the Excel file, and we can see that its size is:1.99mb.
Then we can compress it. In order to make it easier for everyone to see it better, I made a moving picture to show it, as follows:
Select the picture to be compressed first, then click Format, click Compress Picture to open the window of compressed picture, then remove the check box in front of the clipping area only applicable to this picture and delete the picture, then check E-mail: the file may be reduced for * * * to enjoy, and finally click OK.
In this way, the size of the picture becomes smaller, and the size of the entire Excel file also becomes smaller. The following is the size of the compressed Excel file:
You can clearly see that it has changed from the original 1.99MB to 2 14KB.
After that, we can look at the compressed picture again. The following is the effect of compressing the picture:
As can be seen from the above picture, the clarity of the picture has basically not changed, and the whole picture is still very clear and will not become blurred.
Image compression method in excel
First, process the picture before inserting it.
If the picture has not been inserted into the excel document, it is best to use special software Photoshop or other tools (such as the drawing tool that comes with the system) to process the picture into an appropriate size and picture format. General picture format TIFF & gtJPG & gt；; GIF. That is to say, the same picture has different formats and different volumes.
Second, the built-in tool completes excel image compression.
In version 20 10, there are two settings related to excel image compression:
1. Click File-Options-Advanced-Image Size and Quality, and make your selections as needed.
2.excel image compression
Excel compresses pictures, which can change the resolution and size of pictures to meet special purposes.
Operation method: Select a picture, and click Drawing Tools → Format Tab → Adjust Group → Compress Picture.
By default, when the Compress Pictures dialog box pops up, click OK.
If "Only for the selected picture" is not checked, this setting will be effective for the compressed picture function performed in the future, otherwise it will only be effective for the currently selected picture.
Third, the skills related to excel image compression.
Sometimes there are not many pictures inserted, so it is theoretically impossible to have such a large amount of data. This situation is mostly caused by taking old files and directly removing the contents and modifying them. A large number of pictures were posted before this file. Due to the influence of the old file, the file volume will be very large. Copying a useful data source into a new file and then "Save As" can also reduce the file size.
Fourthly, excel image compression is completed with the help of third-party small software.
NXPowerLite small software is recommended, which can achieve high compression rate.
NXPowerLite can optimize MicrosoftWord documents, Excel spreadsheets and PowerPoint presentation files by intelligently compressing pictures and text.
Just select the Word, Excel or PowerPoint file to be compressed, then select the appropriate compression level, and click the "Compress" button to complete the operation.
Compression settings can be customized according to actual needs, and the best balance point between quality and compression ratio can be selected according to actual needs.
Provide the download address of NXPowerLite: #
Download the compressed package, decompress it, and double-click! ) install the registry file to register, and then click the NXPowerLite icon to use the software.
The following is an interface screenshot of excel image compression using NXPowerLite:
Compression method of excel
1. First open the file and insert the picture.
2. Then cut the picture to the size you want and save it.
3. Right-click the EXCEL table, and then click Properties. You can see that the current table is 869KB.
4. Open the EXCEL form, click the picture, click the format, and then click the compressed picture.
5. Click OK in the recompress picture window.
6. Click the Save icon in the upper left corner to save the compressed picture.
7. Right-click the EXCEL table, and then click Properties to view the table size, which is reduced to 10 1KB.
Methods and steps of image compression in excel-related articles;
★ Method and step diagram of image compression in ★excel
★excel20 10 image compression method
★ Illustrative steps of compressing excel files.
★ How to compress pictures in ★Excel tutorial
★ Image compression method in ★excel
★ How to compress pictures in excel
★ image compression method in excel 2010
Explain in detail the methods and steps of ★excel batch scaling pictures.
★ Image Compression Course in ★excel
var _ HMT = _ HMT | |[]； (function(){ varhm =(" script ")； =""; vars =(" script ")[0]； s.(hm，s)； })();