Fix Excel Shapes and Text Boxes Changing Size Between Versions
Question details
The user needs to prevent shapes, ovals, and text boxes from distorting or resizing when opening a spreadsheet file on different computers or software versions.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Opening a workbook on different computers, Excel versions, or with different display scalings and printer settings.
- Observed behavior
- Shapes and text boxes become distorted, stretch into ovals, or change dimensions unexpectedly.
Ensure you have the exact fonts used in the document installed on all computers and that you are saving your file in the newer .xlsx format rather than the legacy .xls format.
Lock Shape Aspect Ratio and Cell Properties
Adjust the shape's size and properties so it doesn't automatically resize with spreadsheet cells.
Shapes and text boxes are often set to resize dynamically when the underlying rows or columns change. By locking their aspect ratio and positioning properties, you prevent distortion caused by formatting differences.
Select the distorted shape in your worksheet and navigate to 'Shape Format' > 'Size' in the top ribbon.
For a perfect circle or square, manually type identical values for both the Height and Width fields.
Click the small arrow in the corner of the Size group to open 'Size and Properties'. Check the 'Lock aspect ratio' box.
Under the Properties section, select 'Move but don't size with cells' to ensure row or column adjustments do not warp the shape.

Standardize Display and Printer Settings
Align system display scaling and default printers to ensure Excel renders worksheet layouts consistently.
Resolve Version Compatibility Issues
Update the file format to ensure graphics and WordArt are supported across different Excel builds.
How to Lock Shape Sizes in WPS Spreadsheet
WPS Spreadsheet offers precise object formatting tools that are fully compatible with Excel files, ensuring your shapes and text boxes never distort across devices.
- 1. Select the Shape: Open your spreadsheet in WPS Office and click on the shape or text box that needs adjustment.
- 2. Open Format Settings: Right-click the selected object and choose 'Format Object' from the context menu.
- 3. Navigate to Properties: In the right-hand properties pane, navigate to the 'Size & Properties' tab.
- 4. Adjust Sizing Rules: Check the 'Lock aspect ratio' box and select the 'Move but don't size with cells' option.
- 5. Save the Document: Save your spreadsheet as an .xlsx file. The shape's dimensions will now remain strictly consistent on any device.

Frequently Asked Questions
Why does a perfect circle become an oval when I email my Excel file?
This happens if the shape is set to 'Move and size with cells' and the recipient's computer has different default fonts or display scaling. These differences alter the row and column dimensions, which in turn stretches the shape into an oval.
Does changing my default printer really affect Excel shapes?
Yes. Excel uses the default printer's drivers to calculate page layout, margins, and scaling. Standardizing the default printer to a digital printer like 'Microsoft Print to PDF' on all computers can prevent unexpected layout shifts.
Will saving as .xlsx fix shape distortion?
It can significantly help. The newer .xlsx format handles graphic objects like shapes, text boxes, and WordArt much better than the legacy .xls format, reducing compatibility errors and visual distortions between newer and older software versions.
How do I apply these size settings to multiple shapes at once?
Hold down the Ctrl key while clicking each shape to select multiple objects. Then, right-click, choose 'Size and Properties,' and apply the 'Move but don't size with cells' setting to lock them all simultaneously.




