Formatting Issues

How to Set Exact Shape and Image Sizes in Excel

Ayan MasoodAyan Masood Nov 10, 2026 871 views

Question details

The user needs to resize multiple shapes and images to exact measurements (such as 1.4 cm) without the application automatically altering the dimensions.

How to Set Exact Shape and Image Sizes in Excel
Product
Microsoft Excel
Device & OS
Windows
Scenario
Resizing multiple shapes and images simultaneously to precise dimensions.
Observed behavior
Excel applies rounding, snapping, or conversion differences, preventing the objects from retaining the exact specified dimensions when resized together.
Before you start

Ensure that the shapes and images you want to resize are ungrouped, and check if their 'Lock aspect ratio' setting is disabled so you can adjust height and width independently.

Solution 1Recommended

Disable Snap Settings and Verify Display Scaling

Turn off Excel's snap-to-grid features and check Windows scaling to prevent automatic rounding of your image dimensions.

Excel often converts dimensional units into pixels based on your screen settings. Custom display scales or automatic alignment features can force your exact measurements to snap to the nearest pixel or gridline.

1
Disable Snap to Grid and Shape

Navigate to the Page Layout or Picture Format tab in Excel. Click on the 'Align' dropdown menu and ensure that both 'Snap to Grid' and 'Snap to Shape' are unchecked.

2
Check Windows Display Scaling

Go to your Windows Settings, then navigate to System > Display. Ensure your scaling is set to a standard 100%. Custom scales like 125% or 150% can cause pixel-to-centimeter conversion errors.

3
Resize Objects Individually

Select each shape or image one by one, right-click, choose 'Size and Properties', and manually enter the exact height and width to prevent multi-selection rounding issues.

Disable Snap Settings and Verify Display Scaling
Precise Object Formatting

Easily Manage Shape and Image Sizes in WPS Office

WPS Spreadsheet provides intuitive and precise controls for sizing shapes and images, avoiding frustrating rounding errors. You can easily format multiple objects exactly to your specifications.

  1. 1. Open your spreadsheet: Launch WPS Spreadsheet and open the document containing the shapes and images you need to adjust.
  2. 2. Select your objects: Hold down the Ctrl key and click on the shapes or pictures you want to resize to select them simultaneously.
  3. 3. Access Size properties: Right-click the selected objects and choose 'Format Object'. Navigate to the 'Size' tab in the right-hand panel.
  4. 4. Set exact dimensions: Enter your desired measurements in the Height and Width boxes, then press Enter to apply the exact size to all selected items without unexpected rounding.
Select and format multiple objects simultaneously without arbitrary snapping.Highly compatible with Microsoft Excel formats including .xlsx and .xls.Lightweight, fast, and completely free to download.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel slightly change my shape size after I type it?

Excel converts physical measurements like centimeters or inches into screen pixels. Depending on your Windows display scaling (such as 125%), this math conversion often results in rounding, causing the dimension to snap to the nearest whole pixel.

Can I resize shapes in PowerPoint and move them to Excel?

Yes. PowerPoint's graphics engine handles objects slightly differently and is optimized for design. You can set the exact dimensions of your shapes in PowerPoint, copy them, and paste them into Excel to retain their precise size.

How do I unlock the aspect ratio when resizing an image?

Right-click the image or shape, select 'Size and Properties', and under the 'Size' section, uncheck the box that says 'Lock aspect ratio'. This allows you to adjust the height and width independently of one another.