Formatting Issues

How to Resize Pictures and Text Boxes with Excel Cells

Maira Mehtab Sep 20, 2026 869 views

Question details

The user wants to configure pictures and text boxes in Excel so that they automatically adjust their size to match the dimensions of the underlying cells while preserving aspect ratios and text formatting.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adjusting spreadsheet layouts where images and text boxes need to scale dynamically with cell resizing without breaking the layout.
Observed behavior: Pictures can be inserted directly into cells using Microsoft 365's Place in Cell feature, though compatibility varies between web and desktop versions. Text boxes remain floating objects and do not support this feature natively, requiring manual property adjustments.

Before you start

Ensure your Microsoft 365 subscription is up to date, as newer features like Place in Cell might not be available immediately on certain enterprise update channels.

Solution 1Recommended

Use the Place in Cell Feature for Pictures

Microsoft 365 allows you to insert images directly into a cell, making them resize automatically.

This modern feature embeds the image directly into the cell background instead of floating over the grid, ensuring it perfectly respects row and column dimension changes while maintaining proportions.

Access the Insert Menu

Go to the Insert tab on the Excel ribbon.

Select Place in Cell

Click on Pictures and select 'Place in Cell' from the dropdown menu.

Choose the Image

Choose the image source (such as This Device) and select the picture you want to insert.

Adjust the Cell

The picture is now embedded. Adjust the row height or column width, and the picture will resize automatically.

Version Compatibility: This feature might show an 'unknown value' error when opened in older desktop applications or if your enterprise channel has not received the update yet.

Solution 2

Configure Object Properties for Text Boxes

Since text boxes cannot be placed directly into cells, you must configure their formatting properties to move and size with cells.

Seamless Spreadsheet Formatting

Easily Manage Objects and Images with WPS Spreadsheet

WPS Spreadsheet offers an intuitive way to manage floating objects, text boxes, and images, ensuring they align perfectly with your cell data without complex version limitations.

1. Open your Document: Open your spreadsheet file in WPS Spreadsheet.
2. Insert Object: Insert your image or text box from the Insert tab and place it over the target cell.
3. Format Object: Right-click the object and select 'Format Object' from the menu.
4. Set Properties: Under the Properties tab, check 'Move and size with cells' to ensure it scales perfectly with your grid.

Highly compatible with Microsoft Excel (.xlsx) formatsEasy property adjustments for floating shapes, text boxes, and imagesFree and lightweight alternative for robust daily spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does my picture show an unknown value error in Excel desktop?

This usually happens if you used the 'Place in Cell' feature in Excel for the Web, but your desktop application is on an older enterprise update channel that does not yet support rendering in-cell images.

Can I embed a text box directly inside a cell like a picture?

No, Excel's 'Place in Cell' feature currently only supports pictures. Text boxes remain floating objects, but you can make them resize with cells by right-clicking them, going to Size and Properties, and selecting 'Move and size with cells'.

How do I preserve the image proportions when resizing cells?

When using the 'Place in Cell' feature, Excel automatically preserves the aspect ratio. If you are using a floating object, you can lock the aspect ratio by checking 'Lock aspect ratio' in the Size and Properties menu.

Will bulleted text inside a text box scale when the cell resizes?

If the text box is set to 'Move and size with cells', the physical box will resize. However, the font size inside the box will not scale automatically; you may need to adjust font sizes or allow text wrapping manually to fit the newly sized box.

Excel & Data Problems