Formatting Issues

Why Excel Resizes Pictures and Changes Column Widths (How to Fix)

Huda Qurayshi Sep 30, 2026 869 views

Question details

The user wants to know why Excel alters image sizes, aspect ratios, and column widths automatically, and how to prevent these formatting changes from occurring.

How to Stop Excel from Resizing Pictures and Changing Column Widths

Product: Excel
Device & OS: not provided
Scenario: Zooming in or out, saving, reopening, or moving a workbook to a different monitor or display.
Observed behavior: Pictures are resized automatically, lose their original aspect ratio, and column widths change unexpectedly across different views.

Before you start

Before troubleshooting, ensure that your Windows display scaling is set to a standard value (like 100%) on all your monitors to accurately assess whether the issue is caused by Excel or your system's resolution settings.

Solution 1Recommended

Lock Picture Size and Aspect Ratio Properties

Configure Excel's object properties to prevent images from resizing or moving when column widths are adjusted or zoom levels change.

Open Size and Properties

Right-click the image that is resizing unexpectedly and select 'Size and Properties' from the context menu.

Lock Aspect Ratio

In the formatting pane under the 'Size' section, check the box for 'Lock aspect ratio' to maintain the picture's original proportions.

Adjust Object Positioning

Expand the 'Properties' section in the same pane and select the option 'Don't move or size with cells'. This detaches the image's dimensions from the underlying grid.

Lock Picture Size and Aspect Ratio Properties

Consistent Layouts: Applying these settings ensures your images remain exactly where you placed them, regardless of how the spreadsheet cells are manipulated.

Solution 2

Standardize Display Scaling and Update Drivers

Fix minor sizing discrepancies caused by screen resolution, zoom level, and pixel conversion across different monitors.

Control Image and Column Formatting Easily with WPS Office

If Excel's scaling quirks continue to disrupt your workflow, WPS Spreadsheet offers robust object formatting tools to ensure your images and column widths remain stable and precise.

1. Open your Workbook in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet file.
2. Format Object: Right-click the inserted image and select 'Format Object' from the dropdown menu.
3. Lock Image Properties: Navigate to the Properties tab in the right-hand pane and choose 'Don't move or size with cells' to secure the formatting.

Free and lightweight office suiteFully compatible with Microsoft Excel formats (.xlsx, .xls)Precise control over image placement and locked aspect ratiosStable layout rendering across multiple displays and zoom levels

microsoft office alternative - wps office

Frequently Asked Questions

Why do my column widths change when I open Excel on another monitor?

Excel calculates column widths based on the default system font and current display scaling. When moving to a monitor with a different resolution or scaling setting, Excel recalculates these pixel values, which can cause minor formatting shifts.

How can I view an image clearly without zooming the whole worksheet?

Newer versions of Excel include a magnification feature. You can simply right-click an image and select the option to magnify it, allowing you to view details without physically resizing the picture or changing the worksheet layout.

Does zooming in and out permanently affect picture aspect ratios?

Zooming changes the visual display size, but sometimes Excel's rendering engine fails to maintain the correct aspect ratio on screen. Locking the aspect ratio within the picture's 'Size and Properties' menu prevents permanent distortion to the file itself.

Document & File Issues