Formatting Issues

How to Fix Excel Resizing Images Inserted into Cells

Maira Mehtab Oct 10, 2026 873 views

Question details

Users experience unexpected resizing of pictures and shapes when inserted into Excel cells.

How to Fix Excel Resizing Images Inserted into Cells

Product: Microsoft Excel
Device & OS: not provided
Scenario: Inserting, formatting, and managing multiple images or shapes within spreadsheet cells.
Observed behavior: Images or shapes change dimensions unexpectedly, often influenced by row height, column width, or default object placement properties rather than screen resolution.

Before you start

Before making changes, verify the current dimensions of your rows and columns, as adjusting them later might affect how images behave if they are set to move and size with cells.

Solution 1Recommended

Adjust Picture Format Properties

Modify the object properties to control how the image interacts with cell resizing.

By default, Excel may link the size of an inserted image to the cell it is placed over. Changing the object properties allows you to decouple the image size from the cell dimensions.

Open Format Picture

Right-click the image or shape you want to fix and select 'Format Picture' or 'Size and Properties' from the context menu.

Locate Properties Settings

In the Format Picture pane, navigate to the 'Size & Properties' tab (the icon with a green square and measurement lines) and expand the 'Properties' section.

Change Placement Options

Select either 'Move but don\'t size with cells' or 'Don\'t move or size with cells' to prevent the image from automatically resizing when row heights or column widths change.

Lock Aspect Ratio

Expand the 'Size' section in the same pane and check 'Lock aspect ratio' if you want to ensure the image does not stretch disproportionately when manually resized.

Solution 2

Use a VBA Macro for Exact Dimensions and Placement

Utilize VBA to strictly define the width, height, and exact centered placement of multiple shapes.

Efficient Spreadsheet Tool

Easily Manage Inserted Images in WPS Spreadsheet

WPS Spreadsheet provides an intuitive and highly compatible interface for managing images in your worksheets. You can easily adjust object properties to lock aspect ratios and control how images respond to cell changes, completely free.

1. Open Your Workbook: Launch WPS Spreadsheet and open your spreadsheet document containing the images.
2. Insert or Select an Image: Go to the 'Insert' tab and click 'Picture' to add an image, or click on an existing image in your worksheet.
3. Access Object Properties: Right-click the selected image and choose 'Format Object' from the dropdown menu to open the right-hand properties pane.
4. Adjust Sizing Preferences: Navigate to the 'Size & Properties' tab. Under 'Properties', choose 'Move but don\'t size with cells' to prevent unwanted resizing when formatting rows or columns.

100% compatible with Microsoft Excel (.xlsx) filesIntuitive 'Format Object' pane for precise image controlFree, lightweight, and fast spreadsheet processing capabilitiesEasy toggles to lock aspect ratio and prevent unwanted resizing

microsoft office alternative - wps office

Frequently Asked Questions

Does screen resolution cause Excel images to resize unexpectedly?

Generally, no. Screen resolution is rarely the reason for universal image resizing across a worksheet. The behavior is usually dictated by the object's properties (such as 'Move and size with cells') and the specific dimensions of the underlying rows and columns.

How do I keep an image from distorting when I resize it?

To prevent distortion, right-click the image, select 'Size and Properties', and ensure the 'Lock aspect ratio' box is checked. This forces the image to maintain its original proportions when you drag its sizing handles.

Can I automatically center images inside Excel cells?

Excel does not have a native one-click button to perfectly center an image inside a cell. However, you can achieve this by using a VBA macro that calculates the cell's top and left dimensions, subtracts the image's dimensions, and divides by two to set precise margins.

Document & File Issues