To compress images in Excel, click any picture, open the Picture Format tab, choose Compress Pictures, clear Apply only to this picture, and pick a resolution as low as Email 96 ppi. Clearing that one checkbox is the whole of how to compress images in Excel, because it re-encodes every embedded picture at once, though it silently skips any photo you placed inside a cell.
I built the browser compressor this site runs on and read image files at the byte level, so this is the honest Excel version: the exact dialog, the one gotcha that makes people think compression failed, the workbook weight that is not even image data, and when a browser tool beats doing it in Excel at all. A bloated spreadsheet is one case of the wider job of getting images small enough for email, the web, and upload forms.
How to compress images in Excel in one pass
Select any picture, and on the Picture Format tab that appears, choose Compress Pictures in the Adjust group, clear Apply only to this picture, pick a resolution, and click OK. That sequence re-encodes every embedded picture in the workbook at once, not just the one you had selected (Microsoft Support, reduce the file size of your Excel spreadsheets). It is the same Office dialog you get in Word and PowerPoint, so if you know one you know all three.
Here is the whole dialog before the steps, because knowing what each control does is the difference between fixing a workbook and thinking you fixed it.
| Control | Where it lives | What it does |
|---|---|---|
| Compress Pictures | Picture Format, Adjust group | Re-encodes pictures at a chosen ppi |
| Apply only to this picture | Compress Pictures dialog | Cleared, it hits every image at once |
| Delete cropped areas | Compress Pictures dialog | Permanently drops hidden cropped data |
| Target output | Compress Pictures dialog | Sets the ppi: HD, Print, Web, or Email |
Compress pictures in Excel with one dialog
- Click any picture once so the Picture Format tab appears. If you cannot see that tab, no picture is selected, which is the usual reason the option seems missing.
- On the Picture Format tab, in the Adjust group, select Compress Pictures.
- Clear Apply only to this picture. It is checked by default, and left checked it compresses only the one picture you happened to click, the single most common reason people believe they shrank a workbook and changed nothing.
- Tick Delete cropped areas of pictures if you are done cropping. It is real savings but permanent once you save, covered below.
- Under Resolution pick a target such as Web 150 ppi or Email 96 ppi, then click OK. Excel gives no on-screen confirmation, so check the saved file size to confirm it worked.
To compress image size in Excel this is the entire method. Everything else on this page is a faster route to the same dialog, the one picture type it refuses to touch, or the workbook weight that is not image data at all.
Why won't Excel compress a picture placed in a cell?
Because a picture placed in a cell is a different object from a floating picture, and Compress Pictures only works on the floating kind. Excel's newer "picture in cell" feature, and images pulled in with the IMAGE() function, live inside the cell value rather than on top of the grid, so selecting one never shows the Picture Format tab and never offers Compress Pictures at all. This is the single biggest Excel-specific trap, and it is all over the help forums because nothing on screen explains it.
Move an in-cell picture over the cells first
Right-click the picture. If you see Place over Cells, the image is currently in the cell and cannot be compressed where it sits (Neuxpower, reduce Excel file size). Choose Place over Cells to convert it to a floating picture, then run Compress Pictures on it the normal way. Once compressed you can leave it floating or, if the layout needs it back in the grid, place it in the cell again at the smaller size.
The IMAGE() function needs a different fix
A picture loaded with the IMAGE() function is not stored in the file the way a pasted photo is; it is fetched from the URL in the formula, so there is no embedded blob for Compress Pictures to shrink and no way to point the dialog at it. The fix is to compress the source: shrink the image at its web address, or download it, compress it, host the smaller version, and point the formula there. For a workbook full of catalog thumbnails that alone can cut load time and the saved file's overhead more than any in-Excel setting.
Which resolution should you choose, HD, Print, Web, or Email?
Match the resolution to where the workbook is going, not to whatever feels safest. The four Target output options map cleanly to four destinations, and the ppi you pick is the single biggest lever on the final size (Avantix Learning, compress images to reduce file size).
| Option | ppi | Best for |
|---|---|---|
| HD | 330 | High-definition displays |
| 220 | Printing, the Office default | |
| Web | 150 | On-screen workbooks |
| 96 | Maximum compression |
The rule I use: Email 96 ppi for any workbook that will only be read on a screen or attached to a message, Web 150 ppi for a dashboard someone might zoom slightly, Print 220 ppi only when a sheet is genuinely going to a printer, and HD 330 ppi almost never, because it barely shrinks anything. One catch before you open the dialog expecting all four: Excel only offers resolutions equal to or lower than a picture's current resolution, so a screenshot already saved for the web will never show the HD option, because there is no detail to add back.
How do you compress every picture at once, or lower Excel's default?
You clear one checkbox for a one-time sweep, or change a setting so every future save compresses automatically. The one-time sweep is Compress Pictures with Apply only to this picture cleared, from the section above. The automatic route lives in Options and is worth setting on any workbook you are still adding photos to.
Set a lower default resolution
Go to File, then Options, then Advanced, and scroll to the Image Size and Quality section. Set Default resolution to 150 ppi or lower, tick Discard editing data so Excel drops the undo history stored beside cropped pictures, and make sure Do not compress images in file is unchecked (Microsoft Support, reduce the file size of your Excel spreadsheets). These settings live with the one workbook, so set them early. From then on every save downsamples new pictures toward that ceiling without you opening the dialog, the automatic way to reduce Excel file size as you work.
Compress the whole workbook in one action
With Apply only to this picture cleared, a single OK hits every floating picture on every sheet, so you do not walk the workbook picture by picture. That is the fast way to compress Excel file size on a spreadsheet someone else handed you, thick with uncompressed screenshots you never chose. Run it once at the end, then check the saved size on disk.
What else bloats an Excel workbook besides images?
Often more than the pictures do. A spreadsheet hides weight in places a document never has, and on a heavy workbook these can dwarf the images (Microsoft Support, reduce the file size of your Excel spreadsheets). Work through these alongside Compress Pictures.
| Lever | Where | Why it helps |
|---|---|---|
| Save as Binary Workbook | File, Save As, .xlsb | Stores the workbook in a smaller binary container |
| Drop the pivot cache | PivotTable Analyze, Options, Data | Stops saving a second hidden copy of the source data |
| Delete unused worksheets | Right-click sheet tab, Delete | Removes formatting and cached ranges you forgot |
| Clear excess formatting | Find and Select, whole columns | Kills formatting applied far past the real data |
The one that surprises people is the pivot cache: uncheck Save source data with file and check Refresh data when opening the file, and a workbook can shrink hard with no visible change, though everyone who opens it then needs access to the source to refresh it. Saving as Binary Workbook is the other quiet win, since the .xlsb container is smaller than .xlsx, but it is worth knowing the tradeoff first: some older tools and a few add-ins cannot read .xlsb, so keep an .xlsx copy if the file has to travel. And do not reach for a zip tool to fix it. An .xlsx is already a zipped container, so re-zipping it usually saves nothing and can even make it larger (Microsoft Q&A, reduce Excel file size). If you want a smaller file, compress the pictures and drop the caches; do not re-zip the workbook.
Should you compress photos before you insert them into Excel?
Yes, when the workbook matters, and if you only have time for one pass, compress before the photos go in. Compress Pictures applies one resolution to every image uniformly, while pre-compressing lets you decide how hard each picture gets hit, which is exactly the control an expense report or an inventory sheet needs. Here is the payoff worked out on the site's own figure, where a 4.5 MB phone photo comes back around 0.9 MB at quality 80.
| Twenty receipt photos in one workbook | Total size | How |
|---|---|---|
| Pasted in at full size | about 90 MB | 20 photos, 4.5 MB each |
| Pre-compressed at quality 80 | about 18 MB | 20 photos, 0.9 MB each |
Reduce Excel file size before the photos go in
Running each photo through a compressor at quality 80 before it enters the sheet keeps you in control of which images get touched and by how much. A receipt you want readable can stay crisp while a decorative header photo gets hit harder, a distinction Compress Pictures cannot make because it treats every picture the same. Pre-compress each receipt photo in the browser first and you set the tradeoff picture by picture, then let Compress Pictures sweep up anything you missed. On the twenty-receipt workbook above, that habit is the whole gap between a 90 MB file that will not attach and an 18 MB one that will.
Why is Compress Pictures greyed out or doing nothing in Excel?
Almost always because the picture is placed in a cell, or because you are in Excel for the web, where Compress Pictures does not exist. If a floating picture is selected and the dialog runs but nothing seems to change, remember Excel shows no confirmation, so check the file size on disk rather than trusting the screen. And if a resolution option looks greyed out, that is the current-resolution ceiling, not a bug: the picture is already at or below that target, so there is nothing to remove. When the dialog genuinely does nothing on a workbook you know is heavy, the weight is usually the pivot cache or unused sheets, not the images.
When should you not compress images in Excel?
Skip Delete cropped areas on any workbook you expect to keep editing, since it forecloses re-cropping for good once you save. Skip Email 96 ppi on a sheet that will be printed at large format or read up close, where 96 ppi looks visibly soft in a way it never would on a screen. And never run Compress Pictures on your only copy of a workbook you care about; save a copy first, because the resolution drop cannot be undone after you save, only before it. Compression is the right default for a spreadsheet headed to email, and the wrong one for a print master.