Formatting Issues

How to Insert and Keep a Picture Inside an Excel Cell

Phi Hung Vo Oct 10, 2026 869 views

Question details

The user wants to insert an image into a specific Excel cell and ensure it stays anchored, moving or resizing automatically alongside the cell.

How to Insert and Keep a Picture Inside an Excel Cell

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adding images to an Excel spreadsheet and keeping them aligned with specific cells for structured data representation.
Observed behavior: The image needs to be embedded directly inside the cell or configured in its properties to move and resize dynamically with cell adjustments.

Before you start

Ensure your image files are saved in a supported format (such as JPG, PNG, or BMP) on your device before attempting to insert them into your spreadsheet.

Solution 1Recommended

Use the 'Place in Cell' Feature (Current Excel Versions)

The most efficient method for modern Excel versions to directly embed an image within a cell.

Recent updates to Excel introduced a dedicated feature allowing images to become the actual value of a cell. This ensures the picture perfectly scales, moves, and filters with the cell contents.

Select the target cell

Click on the specific cell in your worksheet where you want the picture to appear.

Navigate to the Insert tab

Go to the 'Insert' tab on the top ribbon, click on 'Pictures', and choose the 'Place in Cell' option.

Choose your image source

Select where you want to import the image from (e.g., 'This Device') and choose your image file to embed it directly into the cell.

Use the 'Place in Cell' Feature (Current Excel Versions)

Quick Embedded Images: Once placed inside the cell, the image behaves like standard cell text. You can copy, paste, or filter the cell without losing the image alignment.

Solution 2

Use 'Format Picture' to Anchor Image to Cell (Older Excel Versions)

Ideal for older versions of Excel that do not support the direct 'Place in Cell' function.

Efficient Spreadsheet Editor

Insert and Manage Pictures Easily with WPS Spreadsheet

WPS Office provides a highly compatible and user-friendly spreadsheet tool to effortlessly manage your data and media. You can easily insert, format, and anchor pictures to cells in WPS Spreadsheet just like you would in Microsoft Excel.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet. Click on the cell where you want to place the image.
2. Insert the picture: Navigate to the 'Insert' tab on the top menu ribbon and click on 'Picture' to browse for your image file.
3. Format object properties: Once inserted and resized to fit the cell, right-click the image and select 'Format Object' from the context menu.
4. Anchor to the cell: In the right-hand panel, go to the 'Properties' tab and choose 'Move and size with cells' to lock the image to your selected cell.

Seamlessly insert and lock images to cells for perfectly organized spreadsheets.Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Lightweight and completely free to download with a familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my picture float over the cell instead of staying inside it?

By default, standard picture insertion places the image on a separate drawing layer above the grid. To lock it inside, you must either use the modern 'Place in Cell' option or change the image's layout properties to 'Move and size with cells'.

Can I embed multiple pictures into a single Excel cell?

The 'Place in Cell' feature only allows one picture per cell. If you need multiple images together, you will need to insert them as floating images over the worksheet and manually arrange them, or merge multiple adjoining cells to create a larger container.

How do I extract an image that is placed directly inside a cell?

Right-click the cell containing the embedded picture, navigate to the 'Picture in Cell' option in the context menu, and select 'Place over Cells' to turn it back into a floating image, or click 'Save as Picture' to export the file to your computer.

Document & File Issues