There are two ways to compress photos in Excel: compress through Excel’s built-in resize image tool or use a third-party compression tool such as TinyPNG or ImageOptim
How to compress photos in an Excel table
When processing a large number of photos in an Excel table, compressing the photo size can save storage space and improve the processing efficiency of the table. The following are two commonly used methods to compress photos:
1. Use the built-in compression tool
-
Select photos:Click on the one you want to compress photos, or hold down the Ctrl key to select multiple photos.
-
Right-click: Right-click on the selected photo and select "Resize".
-
Select compression options: In the "Adjust Picture" dialog box, select the "Compress Picture" tab.
-
Adjust settings: Select the "Target Size" and "Target Resolution" settings as needed.
-
Apply changes: Click the "OK" button to apply the changes.
2. Use third-party compression tools
-
Download compression tools:There are many free or paid third parties on the Internet Compression tools such as TinyPNG, ImageOptim and OptiPNG.
-
Install the compression tool: Install the compression tool and set it up according to the prompts.
-
Add photos: Drag and drop the photos you want to compress into the compression tool, or add them using the "Add Files" button.
-
Start compression: Click the "Compress" or "Optimize" button to start the compression process.
-
Save the compressed file: After the compression is completed, save the compressed photo as a new file.
No matter which method is used, you need to pay attention to the following points when compressing photos:
-
Choose the appropriate compression rate: The higher the compression rate , the file size is smaller, but the image quality may be reduced.
-
Preview the compression effect: Preview the compression effect before applying changes to ensure you achieve the desired quality and file size.
-
Compress photos regularly: Over time, an increase in the number of photos in an Excel spreadsheet will cause the file size to increase, so compressing photos regularly can keep the spreadsheet efficient.
The above is the detailed content of How to compress excel table photos. For more information, please follow other related articles on the PHP Chinese website!