Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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

first ways 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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.