Formatting Issues

Fix Excel Shapes and Text Boxes Changing Size Between Versions

Aamir Naveed AkramAamir Naveed Akram Nov 10, 2026 869 views

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.

How to Fix Excel Shapes and Text Boxes Changing Size Between 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.
Before you start

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.

Solution 1Recommended

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.

1
Access Size Settings

Select the distorted shape in your worksheet and navigate to 'Shape Format' > 'Size' in the top ribbon.

2
Normalize Dimensions

For a perfect circle or square, manually type identical values for both the Height and Width fields.

3
Lock Aspect Ratio

Click the small arrow in the corner of the Size group to open 'Size and Properties'. Check the 'Lock aspect ratio' box.

4
Prevent Sizing with Cells

Under the Properties section, select 'Move but don't size with cells' to ensure row or column adjustments do not warp the shape.

Lock Shape Aspect Ratio and Cell Properties
Formatting Tip: Once you have perfectly formatted one shape, you can simply duplicate it (Ctrl + D) instead of manually adjusting multiple distorted shapes one by one.
WPS Spreadsheet Solution

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. 1. Select the Shape: Open your spreadsheet in WPS Office and click on the shape or text box that needs adjustment.
  2. 2. Open Format Settings: Right-click the selected object and choose 'Format Object' from the context menu.
  3. 3. Navigate to Properties: In the right-hand properties pane, navigate to the 'Size & Properties' tab.
  4. 4. Adjust Sizing Rules: Check the 'Lock aspect ratio' box and select the 'Move but don't size with cells' option.
  5. 5. Save the Document: Save your spreadsheet as an .xlsx file. The shape's dimensions will now remain strictly consistent on any device.
Free and fully compatible with Microsoft Excel (.xlsx) formatsStable cross-device rendering for shapes, text boxes, and chartsEasy-to-use properties panel to permanently lock aspect ratiosLightweight software that loads graphic-heavy workbooks quickly
microsoft office alternative - wps office

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.