Function Problems

How to Display a Picture from a Cell Reference in Excel

Maira Mehtab Sep 22, 2026 871 views

Question details

The user is trying to display a picture using a cell reference in a formula, but the formula returns a zero instead of the image.

Product: Excel
Device & OS: not provided
Scenario: Referencing a cell that contains a picture to display that picture dynamically using a formula.
Observed behavior: The cell reference formula returns a 0 because the picture is positioned as a floating object over the cell rather than being embedded inside it.

Before you start

Verify that the images you wish to reference are saved locally on your device, as you will need to re-insert them properly into the spreadsheet.

Solution 1Recommended

Insert the Picture Inside the Cell

To allow formulas to recognize and return an image, the picture must be firmly embedded inside the cell rather than floating over it.

Pictures placed over cells are treated as separate floating objects by the spreadsheet software. Because the actual cell beneath the picture is technically empty, any formula referencing that cell will return a zero.

Select the target cell

Click on the specific cell where you want the original image to reside.

Open the Insert menu

Navigate to the 'Insert' tab on the top ribbon and select 'Pictures'.

Choose Place in Cell

Select the 'Place in Cell' option from the dropdown menu, rather than 'Place over Cells'.

Update your formula

Choose your image file and insert it. Your cell reference formula will now correctly display the embedded image instead of a 0.

Reference Successful: Once the image is placed inside the cell, it behaves as cell content and can be successfully called by lookup formulas or direct references.

Solution 2

Correct Formula Sheet References

Remove unnecessary sheet name prefixes in your formula if the reference and the pictures are located on the same worksheet.

Advanced Spreadsheet Features

Easily Manage and Reference Images in Cells with WPS Office

WPS Spreadsheet provides a seamless and intuitive interface for embedding pictures directly into cells, making it incredibly easy to reference them in your formulas without returning zero errors.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your current spreadsheet document.
2. Select the destination cell: Click on the exact cell where you want to embed the picture.
3. Insert the picture: Go to the 'Insert' tab, select 'Picture', and use the embedding tool to lock the image firmly into the cell.
4. Write your reference formula: Enter your standard cell reference formula. WPS Spreadsheet will perfectly recognize and display the embedded image.

Easily embed images directly inside cells with a single clickHighly compatible with Microsoft Excel formulas, functions, and file formatsLightweight software that processes complex spreadsheets quickly

microsoft office alternative - wps office

Frequently Asked Questions

Why does my cell reference formula return a 0 instead of the picture?

This happens when the picture is inserted as a floating object over the cell rather than embedded inside it. The formula reads the data inside the cell itself, which is empty, resulting in a zero.

How can I find a cell's position if an image is floating over it?

If an image is floating over a cell and you need to return the physical location of that cell, you can use the ROW() or COLUMN() functions to determine its exact position.

Can I reference an embedded image from a different worksheet?

Yes, as long as the image is correctly inserted using the 'Place in Cell' method, you can reference it from another sheet by including the proper sheet name prefix in your formula (for example, Sheet2!A1).

Excel & Data Problems