Formatting Issues

How to Fix Image Quality Loss with Excel Place in Cell

Muhammad Talha Sep 28, 2026 870 views

Question details

The user is experiencing continuous degradation of image quality upon reopening an Excel workbook when using the Place in Cell feature, even after modifying compression settings.

How to Fix Image Quality Loss with Excel Place in Cell

Product: Microsoft Excel
Device & OS: not provided
Scenario: Inserting images directly into cells and saving the workbook for later use.
Observed behavior: Images progressively lose resolution, becoming blurry or pixelated every time the Excel file is reopened.

Before you start

Ensure you have the original, high-resolution image files saved on your local drive, as images that have already lost quality inside the workbook cannot be restored.

Solution 1Recommended

Disable Image Compression in Excel Settings

Prevent Excel from automatically reducing the file size and quality of inserted images upon saving.

Excel has a default setting that automatically compresses images to keep the overall workbook file size small. Disabling this feature ensures your original image resolution is preserved.

Open Advanced Options

Click on 'File' in the top ribbon, then select 'Options' at the bottom left. In the Excel Options dialog box, click on 'Advanced'.

Locate Image Settings

Scroll down the list until you find the section labeled 'Image Size and Quality'.

Disable Compression

Check the box next to 'Do not compress images in file'. Additionally, change the 'Default resolution' dropdown menu to 'High fidelity'.

Save Changes

Click 'OK' to apply the settings. Re-insert your original high-resolution images and save the workbook.

Disable Image Compression in Excel Settings

File Size Increase: Choosing 'High fidelity' and disabling compression will significantly increase the overall file size of your Excel workbook if it contains many images.

Solution 2

Use Place Over Cells as a Workaround

Bypass the specific compression bugs associated with the 'Place in Cell' feature by layering images over the grid.

Solution 3

Isolate the Issue with a Test Workbook

Create a simplified test file to determine if the issue is specific to a corrupted workbook or a widespread software bug.

Free Microsoft Office alternative

Try WPS Office to Prevent Image Quality Degradation

If Microsoft Excel continues to compress your images despite changing the settings, consider switching to WPS Office. It's a free, lightweight alternative that handles media elements in spreadsheets smoothly, without unexpected quality loss upon saving.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file.
3. Insert Images Safely: Use the insert tools to add your high-resolution images, confident that their quality will be retained after saving.

Free and lightweight Office suite alternativeSeamlessly compatible with Microsoft Excel (.xlsx) formatsInsert and manage high-quality images without progressive degradationFamiliar user interface with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel automatically compress my images?

Excel compresses images by default to optimize the workbook's file size and improve loading performance. However, this automatic compression can sometimes cause noticeable blurring or pixelation, especially with detailed graphics.

Can I restore the quality of an image that is already blurry in Excel?

No. Once an image is compressed and the workbook is saved and closed, the original quality data is discarded. You must disable compression settings and manually re-insert the original image from your device.

Does saving the Excel file as a PDF preserve image quality?

Saving as a PDF preserves the image quality at its current state in the workbook, provided you select 'Optimize for standard publishing' in the save options. However, it will not enhance images that have already suffered quality loss.

Document & File Issues