Formatting Issues

Fix Excel Picture Disappearing and Showing the Word Picture in a Cell

Maira Mehtab Sep 21, 2026 874 views

Question details

The user experiences an issue where an image inserted into an Excel cell disappears and is replaced by the word 'Picture' when the cell is edited or double-clicked.

Product: Excel
Device & OS: not provided
Scenario: Editing a cell that contains an inserted image.
Observed behavior: The image vanishes during cell editing, and the text representation 'Picture' appears instead because the image is treated as cell data content.

Before you start

Determine if the image needs to be strictly locked inside the cell as a data value, or if it can float above the cell, as changing the insertion method will affect how the image interacts with sorting and filtering.

Solution 1Recommended

Insert the Image as a Floating Picture Over Cells

Switching from an in-cell picture to a floating picture prevents Excel from treating the image as editable text content when you double-click the cell.

Excel treats 'in-cell' pictures as data values, which causes them to temporarily display their text representation ('Picture') when you attempt to edit the cell. To resolve this behavior while keeping the visual layout, you can insert the image so it floats over the spreadsheet grid instead.

Navigate to the Insert tab

Open your Excel workbook and click on the 'Insert' tab on the top ribbon.

Insert the picture

Click on 'Pictures' and select the image you want to add to your spreadsheet.

Place the picture over cells

Ensure you are inserting it as a standard floating picture, avoiding the 'Place in Cell' option.

Configure Size and Properties

Right-click the inserted image, select 'Size and Properties', and under the Properties section, choose 'Move and size with cells' to keep it anchored to its location.

Cell Snapping Tip: Hold down the ALT key on your keyboard while dragging or resizing the floating image to snap it perfectly to the cell borders.

Manage Spreadsheet Images Better

Handle Images in Spreadsheets Easily with WPS Office

WPS Spreadsheet provides a highly intuitive interface for managing images. You can seamlessly switch between floating and embedded images, ensuring your formatting remains intact and easy to edit without confusing text replacements.

1. Open your spreadsheet: Launch WPS Office and open your existing spreadsheet document.
2. Insert a picture: Go to the 'Insert' tab and click 'Picture' to browse and add your image.
3. Adjust layout properties: Right-click the picture and select 'Format Object' to access layout options, choosing to float it over cells.
4. Anchor the image: In the properties panel on the right, select 'Move and size with cells' to ensure it behaves correctly when columns or rows are adjusted.

Fully compatible with Microsoft Excel (.xlsx and .xls) formats.Intuitive picture formatting tools with simple drag-and-drop support.Easily lock floating images to specific cell locations.Lightweight design for faster performance with large spreadsheet files.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel image turn into the word 'Picture'?

When you use the 'Place in Cell' feature in modern versions of Excel, the image becomes the actual data value of the cell. If you enter edit mode by double-clicking or pressing F2, Excel shows the underlying text reference ('Picture') instead of the graphic.

How can I keep my floating picture inside the cell boundaries?

You can manually resize the floating image to fit within the cell. Then, right-click the image, select 'Size and Properties', and choose 'Move and size with cells' from the Properties menu. This ensures the picture stays aligned with the cell if the row or column is resized.

Can I sort and filter rows with floating pictures?

Yes, if you configure the floating picture's properties to 'Move and size with cells' (or 'Move but don't size with cells'), the image will hide, move, or sort appropriately when you apply filters or sort the worksheet data.

Document & File Issues