Compressing the images inside an Excel file usually cuts the workbook size by 50% to 80%, because embedded photos are almost always the heaviest part of the file. A single full-resolution photo from a phone weighs between 3 and 8 MB, and once it has been pasted into a worksheet it stays at that size unless you take action. Cell data, formulas and number formatting add up to a few hundred kilobytes at most; a dozen product photos can push a workbook past the 25 MB email attachment limit before you have typed a single value. Shrinking each image before it goes back into the sheet — or compressing every embedded picture, replacing the originals, and saving — is the fastest reliable way to bring a bloated workbook back down to a shareable size. You can do this with Excel's own Compress Pictures button, or by extracting each image and running it through a browser-based compressor that gives you a live quality slider and a before-and-after comparison.
Why Photos Make Excel Files So Heavy
Excel stores every embedded picture at its full original resolution. A photo from a 12-megapixel phone camera arrives as a 4000×3000 pixel file between 3 and 8 MB; Excel saves it essentially untouched inside the workbook container. Cell data, formulas, and number formatting add up to a few hundred kilobytes at most. One product photo can outweigh the rest of the file ten times over. If a workbook has ballooned past your email attachment limit, the answer is almost never the cells themselves — it is the pictures inside them.
Workbooks grow without warning because Excel duplicates the full image data each time the file is saved, and pasting from the clipboard or drag-and-drop carries the original high-resolution file forward. Over dozens of edits, the file accumulates the same photo multiple times in different positions, multiplying the bloat. Shrinking every image before it goes back into the sheet is the fastest, most reliable way to bring a heavy workbook back down to a shareable size.
Two Ways to Compress Images in an Excel File
There are two practical paths. The first uses Excel's own Compress Pictures button on the Picture Format ribbon. It offers preset resolutions — Print at 220 ppi, Screen at 150 ppi, Email at 96 ppi — and an option to delete cropped regions of the photo. It is a single click, lives entirely inside Excel, and is the right tool when you just need to send the file today.
The second path is to extract each image, run it through a browser-based compressor with a live quality slider, then drop the smaller file back into the worksheet. This produces larger size reductions — typically bringing a 3–8 MB phone photo down to between 200 KB and 1 MB — because you are working from the original bit-for-bit pixels rather than asking Excel to downsample embedded thumbnails. The trade-off is a handful of extra clicks, which is usually worth it when the workbook needs to clear an upload cap or travel by email.
Compress the Images in Your Browser
The most reliable way to shrink the photos inside a heavy workbook is to compress each one before it goes back into Excel. The Image Compressor handles JPG, PNG, and WebP files and runs entirely in your browser, so nothing is uploaded to a server. The tool decodes the file on your device, redraws it onto an HTML5 canvas, and re-encodes it with the format and quality you choose, while showing the original and compressed image stacked in one frame, with a divider line you can pull across the picture.
- Save a copy of the workbook so you always have the original to fall back on.
- Right-click each embedded image in the worksheet and choose "Save as Picture". Save every photo to a single folder so they are easy to find.
- Open the Image Compressor in your browser. Drag the first photo from the folder onto the page — compression starts the moment the file lands.
- Drag the quality slider between 60% and 80% and watch the file size update in real time. The split view lets you pull a divider line across the picture so you can inspect fine detail like hair, gradients, or small text.
- Click Download to save the compressed version. Pick WebP for the smallest file, or stay with JPG if the workbook will be opened on older systems.
- Repeat for every photo, then return to Excel with the new folder of smaller files.
You can also automate the extraction step with a dedicated guide that pulls every embedded image out of a workbook in one click — see Extract Images From Excel: A Browser-Based Alternative if right-clicking each picture one at a time sounds tedious.
Replace the Embedded Images in Your Workbook
With the compressed files saved in a folder, the Excel-side steps are short:
- Back in the worksheet, click each embedded image and press Delete to remove it. Hold Ctrl while clicking to select multiple at once.
- Go to Insert → Pictures → This Device and pick the smaller file you just downloaded. Place it in the same cell or region as the original.
- Check the on-screen appearance. The compressed image should look identical at normal zoom because you resized the file, not the placement on the sheet.
- Save the workbook and compare the new file size in your file manager.
A 3.5 MB phone photo at 70% quality typically lands around 500 KB. That is a 3 MB drop per photo — 3.5 MB − 0.5 MB = 3 MB. Ten such photos in one workbook cut roughly 30 MB off the file size (3 MB × 10 = 30 MB), which is enough to bring a 35 MB report under most email and upload limits.
Picking the Right Format and Quality
The format you choose matters as much as the quality slider. The table below compares how each option behaves inside an Excel workbook.
| Format | Best for | Size behavior | Compatibility |
|---|---|---|---|
| JPG | Photos, product shots, scanned images | Compact format for photographs, though WebP can be smaller at the same visible quality | Universal — every Excel version opens it |
| PNG | Screenshots with sharp text, logos with transparency | Larger than JPG for photos; lossless | Universal — supports transparency |
| WebP | Web publications, modern Office 365 installs | 20–30% smaller than JPG at the same visible quality | Recent Office builds; older Excel versions may not render |
For most workbooks that travel by email or get uploaded to a portal, JPG at 65–75% quality is the safe default. PNG is worth the extra bytes only when the picture contains sharp text, line art, or transparent areas that would blur under JPG compression. WebP is the right pick if every reader of the workbook is on a recent version of Office and you want the smallest file possible.
When the Browser Method Beats Excel's Built-In Tool
Excel's built-in button is one click. The browser compressor is several clicks. So when does the extra effort pay off?
- Privacy. The browser tool never sends the photo anywhere. ID scans, signed contracts, unreleased product shots, and confidential screenshots stay on your machine.
- Bigger size reductions. Extracting, recompressing, and re-inserting typically reduces a 3–8 MB phone photo to between 200 KB and 1 MB, because the recompression step uses your chosen quality target rather than a fixed resolution preset.
- Quality control. The split view lets you check hair, gradients, and small text before you commit. You see the actual file size at every slider position, not a vague Print/Screen/Email preset.
- Format flexibility. Excel's built-in tool does not output WebP. If the smallest file is the goal, a browser compressor that supports WebP has an immediate edge.
A Practical Workflow for a Ten-Image Workbook
The full process on a typical product sheet with ten embedded photos usually takes under ten minutes:
- Save a copy of the workbook as a backup.
- Save every embedded image to a folder (right-click each → Save as Picture, or use the linked extraction guide).
- Run each photo through the Image Compressor at 70% JPG quality.
- Delete the original pictures from the worksheet.
- Insert the compressed files in the same positions.
- Save the workbook and compare file sizes.
On a real phone-photo workbook the result is usually a file around one-seventh of its starting size. That is the difference between a workbook that bounces off an email server and one that lands in the recipient's inbox in seconds.