How to Set Exact Shape and Image Sizes in Excel
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.

- 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.
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.
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.
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.
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.
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.

Use a VBA Macro to Set Exact Dimensions
Running a VBA macro bypasses the user interface limitations and enforces exact measurements across all objects simultaneously.
Use the Duplication Method
Create one perfectly sized template shape and duplicate it to ensure consistency without relying on the multi-select sizing tool.
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. Open your spreadsheet: Launch WPS Spreadsheet and open the document containing the shapes and images you need to adjust.
- 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. Access Size properties: Right-click the selected objects and choose 'Format Object'. Navigate to the 'Size' tab in the right-hand panel.
- 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.

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.




