Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to insert a jpg image inside a cell, or do Excel cells only display alphanumeric characters (or references)?

share|improve this question
This seems like something that could be done with VBA (apparently robihot agrees, having tagged the question with the vba tag). Does anyone know enough about VBA to know whether it is possible? – Firefeather May 12 '11 at 2:27
Answers to this question show how this can be done with VBA… – zeristor Apr 16 '15 at 14:10

There are two ways to insert image to the Excel cell.

First way is inserting image as the background of comments.

  • Right-click on the cell
  • Insert Comment
  • Double-click on the border of the comment
  • Choose the Colors and Lines tab
    -In the Fill section, click the drop-down for Color
  • Choose Fill Effects... | Picture | Select Picture...
  • Choose your picture and click Insert
  • Click OK

the result will be like that

alt text

When you put mouse over the cell, it'll show the picture.

Another way what you can do is anchoring an image to the cell. You've to name the cell first. Right click on the cell, and "Define Name". then right click on the picture , add Hyperlink , choose "Place in this document", you'll see the name you'd set in the Defined Names, then Okay! You'll find out like below.

alt text

You'll need to adjust the size of the image with the cell width/height.

share|improve this answer
mgpyone could you clarify where the image is when you right click on it please? Not sure how to select the image after the name definition. – datatoo Jun 12 '10 at 17:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .